CST_XLA_SOURCE_SALES_RETURN_V

Details

• Schema: FUSION

• Object owner: CST

• Object type: VIEW

Columns

Name

SELLING_LEGAL_ENTITY_ID SELLING_ORG_ID EXTERNAL_SYSTEM_REF_ID CUSTOMER_ID EXTERNAL_SYSTEM_REFERENCE SOURCE_SALES_ORDER_NUMBER SOURCE_SALES_ORDER_LINE_NUMBER DOO_ORDER_NUMBER DOO_LINE_NUMBER RECEIPT_ADVICE_NUMBER BILL_CUST_ACCOUNT_ID BILL_CUST_ACCOUNT_NUMBER BILL_TO_SITE_USE_ID BILL_CUST_CAT_CODE BILL_CUSTOMER_CLASS_CODE BILL_CUST_PARTY_ID BILL_CUST_PARTY_NUMBER BILL_USES_SITE_USE_ID BILL_USES_SITE_USE_CODE SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10

Query

SQL_Statement

SELECT c.selling_legal_entity_id selling_legal_entity_id , c.selling_org_id selling_org_id , c.external_system_ref_id external_system_ref_id , c.customer_id customer_id , c.external_system_reference external_system_reference , cit.source_sales_order_number source_sales_order_number, cit.source_sales_order_line_number source_sales_order_line_number, c.doo_order_number doo_order_number, TO_CHAR(c.doo_line_number) doo_line_number, c.receipt_advice_number receipt_advice_number, cacct.cust_account_id bill_cust_account_id , cacct.account_number bill_cust_account_number, -1 bill_to_site_use_id, hz.category_code bill_cust_cat_code, UPPER(cacct.customer_class_code) bill_customer_class_code, hz.party_id bill_cust_party_id, hz.party_number bill_cust_party_number, -1 bill_uses_site_use_id, cast(null as varchar2(30)) bill_uses_site_use_code, cast(null as varchar2(30)) segment1, cast(null as varchar2(30)) segment2, cast(null as varchar2(30)) segment3, cast(null as varchar2(30)) segment4, cast(null as varchar2(30)) segment5, cast(null as varchar2(30)) segment6, cast(null as varchar2(30)) segment7, cast(null as varchar2(30)) segment8, cast(null as varchar2(30)) segment9, cast(null as varchar2(30)) segment10 FROM cst_sales_order_details c, cst_inv_transactions cit, hz_cust_acct_sites_all casa, hz_cust_accounts cacct, hz_parties hz WHERE cit.sales_order_source_system = c.external_system_reference AND cit.source_sales_order_line_number = TO_CHAR(c.doo_line_number) AND cit.source_sales_order_number = c.doo_order_number AND cit.receipt_advice_number = c.receipt_advice_number AND cacct.cust_account_id = c.customer_account_id AND casa.cust_account_id = cacct.cust_account_id AND hz.party_id = cacct.party_id AND c.bill_to_customer_id = hz.party_id AND c.inventory_organization_id = cit.inventory_org_id AND cit.receipt_advice_number IS NOT NULL