紫光erp實(shí)施項(xiàng)目mdoracle ebs提供給ssmp的視圖

MD.050――OracleEBS作者 建檔日期 08-最近更新 05-版本 :日 作 版 參2016-08-V職位簽字文檔控 OracleEBS由于紫光華山目前尚沒(méi)有主數(shù)據(jù)管理平臺(tái)，因此物料、客戶等主數(shù)據(jù)均在OracleEBS進(jìn)行管理，系統(tǒng)需從OracleEBS這些數(shù)據(jù)。

1NYNCREATEORRECEVIEWH3C_EBS_OU_VIEWSELECTflv.lookup_code"ORG_ID",flv.meaning"ORG_CODE",flv.descriptionFROMfnd_lookup_valuesflvWHERE1=1ANDflv.lookup_type='H3C_OKS_UNIT'ANDflv.enabled_flag='Y'ANDtrunc(SYSDATE)BETWEENtrunc(nvl(flv.start_date_active,SYSDATE))

1Y2N3N4Y5NBILL_TO這一用6N7N8N9Naddress3+NNCREATEOR CEVIEWH3C_EBS_CUSTOMER_VIEWSELECT_id"ORG_ID",hca.account_number"CUSTOMER_NUMBER",hp.party_name"CUSTOMER_NAME",hcsua.location"CUSTOMER_LOCATION",hcsua.site_use_code"LOCATION_USAGE",hl.country"ADD_COUNTRY",vince"ADD_PROVINCE",hl.city"ADD_CITY",hl.countyhl.address1||hl.address2||hl.address3||hl.address4"ADD_DETAIL",FROMhz_parties hz_cust_acct_sites_allhcasa, hz_cust_site_uses_allhcsuaWHEREhp.party_id=hca.party_idANDnvl(hp.status,'I')='A'ANDnvl(hca.status,'I')=ANDnvl(hps.status,'I')='A'ANDnvl(hcasa.status,'I')='A'ANDnvl(hcsua.status,'I')=ANDhca.cust_account_id=hcasa.cust_account_idANDhcasa.party_site_id=hps.party_site_idANDhps.location_id=hl.location_idANDhcasa.cust_acct_site_id=hcsua.cust_acct_site_idAND_id=_idANDEXISTS(SELECTFROMfnd_lookup_valuesflvWHERE1=1ANDflv.lookup_type='H3C_OKS_UNIT'ANDflv.enabled_flag='Y'ANDtrunc(SYSDATE)BETWEENtrunc(nvl(flv.start_date_active,SYSDATE))ANDANDto_number(flv.lookup_code)=1N2Y3N4N5NCREATEOR CEVIEWH3C_EBS_ITEM_VIEWASmsif.segment1 decode(msif.item_type,'TSS',msif.attribute19)"ITEM_TYPE"FROMmtl_system_items_fvlmsifWHERE1= ANDanization_id=

1Y2NCREATEORRECEVIEWH3C_EBS_VAT_TAXASSELECTzoc.lookup_code,FROMzx_output_classifications_vzocWHERE1=1ANDzoc.tax_type='VAT'ANDzoc.enabled_flag='Y'(trunc(SYSDATE)BETWEENtrunc(nvl(zoc.start_date_active,SYSDATE))ANDtrunc(nvl(zoc.end_date_active,SYSDATE)))ANDEXISTS(SELECTFROMfnd_lookup_valuesflvWHERE1=1ANDflv.lookup_type='H3C_OKS_UNIT'ANDflv.enabled_flag='Y'ANDtrunc(SYSDATE)BETWEENtrunc(nvl(flv.start_date_active,SYSDATE))AND

1Y2NCREATEORRECEVIEWH3C_EBS_PAYMENT_TERMS_VIEWSELECT"PAYMENT_TERMS",rtv.descriptionFROMokx_receivables_terms_vrtvWHERE1=1AND(to_date(SYSDATE)BETWEENnvl(rtv.start_date_active,to_date(SYSDATE))AND1Y2NCREATEORRECEVIEWH3C_EBS_RA_KEY_VIEWSELECTffvv.flex_value,FROMfnd_flex_value_setsffvs,fnd_flex_values_vlffvvWHEREffvs.flex_value_set_id=ffvv.flex_value_set_idANDffvs.flex_value_set_name='PA_TSC_WBSRAKey'ANDffvv.enabled_flag='Y'ANDtrunc(SYSDATE)BETWEENtrunc(nvl(ffvv.start_date_active,SYSDATE))AND

1Y2NCREATEORRECEVIEWH3C_EBS_CURRENCY_VIEWSELECTfc.currency_code"CURRENCY_CODE","CURRENCY_NAME"FROMfnd_currenciesfc,fnd_currencies_tlftWHEREfc.currency_code=ft.currency_codeANDft.language=userenv('LANG')ANDSYSDATEBETWEENnvl(fc.start_date_active,SYSDATE)ANDnvl(fc.end_date_active,SYSDATE)ANDnvl(fc.enabled_flag,'N')=TSS1的Y2的NCREATEOR CEVIEWH3C_EBS_TSS_BIZ_TYPE_VIEWSELECTflv.lookup_code,flv.meaningFROMfnd_lookup_valuesflvWHER