CST_XLA_SALES_ORDER_DETAILS_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 SHIP_TO_CUSTOMER_ID EXTERNAL_SYSTEM_REFERENCE SOURCE_SALES_ORDER_NUMBER SOURCE_SALES_ORDER_LINE_NUMBER DOO_ORDER_NUMBER DOO_LINE_NUMBER SALES_ORDER_SHIPMENT_NUMBER RECEIPT_ADVICE_NUMBER BILL_CUST_ACCOUNT_ID SHIP_CUST_ACCOUNT_ID BILL_CUST_ACCOUNT_NUMBER SHIP_CUST_ACCOUNT_NUMBER BILL_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID BILL_CUST_CAT_CODE SHIP_CUST_CAT_CODE BILL_CUSTOMER_CLASS_CODE SHIP_CUSTOMER_CLASS_CODE BILL_CUST_PARTY_ID SHIP_CUST_PARTY_ID BILL_CUST_PARTY_NUMBER SHIP_CUST_PARTY_NUMBER BILL_USES_SITE_USE_ID SHIP_USES_SITE_USE_ID BILL_USES_SITE_USE_CODE SHIP_USES_SITE_USE_CODE DOO_ORDER_TYPE DOO_LINE_TYPE_CODE DOO_ORDER_HEADER_ID SEGMENT1 SEGMENT2 SEGMENT3 SEGMENT4 SEGMENT5 SEGMENT6 SEGMENT7 SEGMENT8 SEGMENT9 SEGMENT10 SHIP_TO_PARTY_ID BILL_TO_PARTY_ID SHIP_TO_PARTY_SITE_ID BILL_TO_PARTY_SITE_ID SOLD_TO_PARTY_ID SHIP_PARTY_SITE_ATTR_CAT SHIP_PARTY_SITE_ATTR_1 SHIP_PARTY_SITE_ATTR_2 SHIP_PARTY_SITE_ATTR_3 SHIP_PARTY_SITE_ATTR_4 SHIP_PARTY_SITE_ATTR_5 SHIP_PARTY_SITE_ATTR_6 SHIP_PARTY_SITE_ATTR_7 SHIP_PARTY_SITE_ATTR_8 SHIP_PARTY_SITE_ATTR_9 SHIP_PARTY_SITE_ATTR_10 SHIP_PARTY_SITE_ATTR_11 SHIP_PARTY_SITE_ATTR_12 SHIP_PARTY_SITE_ATTR_13 SHIP_PARTY_SITE_ATTR_14 SHIP_PARTY_SITE_ATTR_15 SHIP_PARTY_SITE_ATTR_16 SHIP_PARTY_SITE_ATTR_17 SHIP_PARTY_SITE_ATTR_18 SHIP_PARTY_SITE_ATTR_19 SHIP_PARTY_SITE_ATTR_20 SHIP_PARTY_SITE_ATTR_21 SHIP_PARTY_SITE_ATTR_22 SHIP_PARTY_SITE_ATTR_23 SHIP_PARTY_SITE_ATTR_24 SHIP_PARTY_SITE_ATTR_25 SHIP_PARTY_SITE_ATTR_26 SHIP_PARTY_SITE_ATTR_27 SHIP_PARTY_SITE_ATTR_28 SHIP_PARTY_SITE_ATTR_29 SHIP_PARTY_SITE_ATTR_30 SHIP_PARTY_SITE_ATTR_N_1 SHIP_PARTY_SITE_ATTR_N_2 SHIP_PARTY_SITE_ATTR_N_3 SHIP_PARTY_SITE_ATTR_N_4 SHIP_PARTY_SITE_ATTR_N_5 SHIP_PARTY_SITE_ATTR_N_6 SHIP_PARTY_SITE_ATTR_N_7 SHIP_PARTY_SITE_ATTR_N_8 SHIP_PARTY_SITE_ATTR_N_9 SHIP_PARTY_SITE_ATTR_N_10 SHIP_PARTY_SITE_ATTR_N_11 SHIP_PARTY_SITE_ATTR_N_12 SHIP_PARTY_SITE_ATTR_D_1 SHIP_PARTY_SITE_ATTR_D_2 SHIP_PARTY_SITE_ATTR_D_3 SHIP_PARTY_SITE_ATTR_D_4 SHIP_PARTY_SITE_ATTR_D_5 SHIP_PARTY_SITE_ATTR_D_6 SHIP_PARTY_SITE_ATTR_D_7 SHIP_PARTY_SITE_ATTR_D_8 SHIP_PARTY_SITE_ATTR_D_9 SHIP_PARTY_SITE_ATTR_D_10 SHIP_PARTY_SITE_ATTR_D_11 SHIP_PARTY_SITE_ATTR_D_12 BILL_PARTY_SITE_ATTR_CAT BILL_PARTY_SITE_ATTR_1 BILL_PARTY_SITE_ATTR_2 BILL_PARTY_SITE_ATTR_3 BILL_PARTY_SITE_ATTR_4 BILL_PARTY_SITE_ATTR_5 BILL_PARTY_SITE_ATTR_6 BILL_PARTY_SITE_ATTR_7 BILL_PARTY_SITE_ATTR_8 BILL_PARTY_SITE_ATTR_9 BILL_PARTY_SITE_ATTR_10 BILL_PARTY_SITE_ATTR_11 BILL_PARTY_SITE_ATTR_12 BILL_PARTY_SITE_ATTR_13 BILL_PARTY_SITE_ATTR_14 BILL_PARTY_SITE_ATTR_15 BILL_PARTY_SITE_ATTR_16 BILL_PARTY_SITE_ATTR_17 BILL_PARTY_SITE_ATTR_18 BILL_PARTY_SITE_ATTR_19 BILL_PARTY_SITE_ATTR_20 BILL_PARTY_SITE_ATTR_21 BILL_PARTY_SITE_ATTR_22 BILL_PARTY_SITE_ATTR_23 BILL_PARTY_SITE_ATTR_24 BILL_PARTY_SITE_ATTR_25 BILL_PARTY_SITE_ATTR_26 BILL_PARTY_SITE_ATTR_27 BILL_PARTY_SITE_ATTR_28 BILL_PARTY_SITE_ATTR_29 BILL_PARTY_SITE_ATTR_30 BILL_PARTY_SITE_ATTR_N_1 BILL_PARTY_SITE_ATTR_N_2 BILL_PARTY_SITE_ATTR_N_3 BILL_PARTY_SITE_ATTR_N_4 BILL_PARTY_SITE_ATTR_N_5 BILL_PARTY_SITE_ATTR_N_6 BILL_PARTY_SITE_ATTR_N_7 BILL_PARTY_SITE_ATTR_N_8 BILL_PARTY_SITE_ATTR_N_9 BILL_PARTY_SITE_ATTR_N_10 BILL_PARTY_SITE_ATTR_N_11 BILL_PARTY_SITE_ATTR_N_12 BILL_PARTY_SITE_ATTR_D_1 BILL_PARTY_SITE_ATTR_D_2 BILL_PARTY_SITE_ATTR_D_3 BILL_PARTY_SITE_ATTR_D_4 BILL_PARTY_SITE_ATTR_D_5 BILL_PARTY_SITE_ATTR_D_6 BILL_PARTY_SITE_ATTR_D_7 BILL_PARTY_SITE_ATTR_D_8 BILL_PARTY_SITE_ATTR_D_9 BILL_PARTY_SITE_ATTR_D_10 BILL_PARTY_SITE_ATTR_D_11 BILL_PARTY_SITE_ATTR_D_12 SHIP_CUST_SITE_ATTR_CAT SHIP_CUST_SITE_ATTR_1 SHIP_CUST_SITE_ATTR_2 SHIP_CUST_SITE_ATTR_3 SHIP_CUST_SITE_ATTR_4 SHIP_CUST_SITE_ATTR_5 SHIP_CUST_SITE_ATTR_6 SHIP_CUST_SITE_ATTR_7 SHIP_CUST_SITE_ATTR_8 SHIP_CUST_SITE_ATTR_9 SHIP_CUST_SITE_ATTR_10 SHIP_CUST_SITE_ATTR_11 SHIP_CUST_SITE_ATTR_12 SHIP_CUST_SITE_ATTR_13 SHIP_CUST_SITE_ATTR_14 SHIP_CUST_SITE_ATTR_15 SHIP_CUST_SITE_ATTR_16 SHIP_CUST_SITE_ATTR_17 SHIP_CUST_SITE_ATTR_18 SHIP_CUST_SITE_ATTR_19 SHIP_CUST_SITE_ATTR_20 SHIP_CUST_SITE_ATTR_21 SHIP_CUST_SITE_ATTR_22 SHIP_CUST_SITE_ATTR_23 SHIP_CUST_SITE_ATTR_24 SHIP_CUST_SITE_ATTR_25 SHIP_CUST_SITE_ATTR_26 SHIP_CUST_SITE_ATTR_27 SHIP_CUST_SITE_ATTR_28 SHIP_CUST_SITE_ATTR_29 SHIP_CUST_SITE_ATTR_30 SHIP_CUST_SITE_ATTR_N_1 SHIP_CUST_SITE_ATTR_N_2 SHIP_CUST_SITE_ATTR_N_3 SHIP_CUST_SITE_ATTR_N_4 SHIP_CUST_SITE_ATTR_N_5 SHIP_CUST_SITE_ATTR_N_6 SHIP_CUST_SITE_ATTR_N_7 SHIP_CUST_SITE_ATTR_N_8 SHIP_CUST_SITE_ATTR_N_9 SHIP_CUST_SITE_ATTR_N_10 SHIP_CUST_SITE_ATTR_N_11 SHIP_CUST_SITE_ATTR_N_12 SHIP_CUST_SITE_ATTR_D_1 SHIP_CUST_SITE_ATTR_D_2 SHIP_CUST_SITE_ATTR_D_3 SHIP_CUST_SITE_ATTR_D_4 SHIP_CUST_SITE_ATTR_D_5 SHIP_CUST_SITE_ATTR_D_6 SHIP_CUST_SITE_ATTR_D_7 SHIP_CUST_SITE_ATTR_D_8 SHIP_CUST_SITE_ATTR_D_9 SHIP_CUST_SITE_ATTR_D_10 SHIP_CUST_SITE_ATTR_D_11 SHIP_CUST_SITE_ATTR_D_12 BILL_CUST_SITE_ATTR_CAT BILL_CUST_SITE_ATTR_1 BILL_CUST_SITE_ATTR_2 BILL_CUST_SITE_ATTR_3 BILL_CUST_SITE_ATTR_4 BILL_CUST_SITE_ATTR_5 BILL_CUST_SITE_ATTR_6 BILL_CUST_SITE_ATTR_7 BILL_CUST_SITE_ATTR_8 BILL_CUST_SITE_ATTR_9 BILL_CUST_SITE_ATTR_10 BILL_CUST_SITE_ATTR_11 BILL_CUST_SITE_ATTR_12 BILL_CUST_SITE_ATTR_13 BILL_CUST_SITE_ATTR_14 BILL_CUST_SITE_ATTR_15 BILL_CUST_SITE_ATTR_16 BILL_CUST_SITE_ATTR_17 BILL_CUST_SITE_ATTR_18 BILL_CUST_SITE_ATTR_19 BILL_CUST_SITE_ATTR_20 BILL_CUST_SITE_ATTR_21 BILL_CUST_SITE_ATTR_22 BILL_CUST_SITE_ATTR_23 BILL_CUST_SITE_ATTR_24 BILL_CUST_SITE_ATTR_25 BILL_CUST_SITE_ATTR_26 BILL_CUST_SITE_ATTR_27 BILL_CUST_SITE_ATTR_28 BILL_CUST_SITE_ATTR_29 BILL_CUST_SITE_ATTR_30 BILL_CUST_SITE_ATTR_N_1 BILL_CUST_SITE_ATTR_N_2 BILL_CUST_SITE_ATTR_N_3 BILL_CUST_SITE_ATTR_N_4 BILL_CUST_SITE_ATTR_N_5 BILL_CUST_SITE_ATTR_N_6 BILL_CUST_SITE_ATTR_N_7 BILL_CUST_SITE_ATTR_N_8 BILL_CUST_SITE_ATTR_N_9 BILL_CUST_SITE_ATTR_N_10 BILL_CUST_SITE_ATTR_N_11 BILL_CUST_SITE_ATTR_N_12 BILL_CUST_SITE_ATTR_D_1 BILL_CUST_SITE_ATTR_D_2 BILL_CUST_SITE_ATTR_D_3 BILL_CUST_SITE_ATTR_D_4 BILL_CUST_SITE_ATTR_D_5 BILL_CUST_SITE_ATTR_D_6 BILL_CUST_SITE_ATTR_D_7 BILL_CUST_SITE_ATTR_D_8 BILL_CUST_SITE_ATTR_D_9 BILL_CUST_SITE_ATTR_D_10 BILL_CUST_SITE_ATTR_D_11 BILL_CUST_SITE_ATTR_D_12

Query

SQL_Statement

SELECT csod.selling_legal_entity_id selling_legal_entity_id, csod.selling_org_id selling_org_id, csod.external_system_ref_id external_system_ref_id, csod.customer_id customer_id, csod.ship_to_customer_id ship_to_customer_id, csod.external_system_reference external_system_reference, NULL source_sales_order_number, NULL source_sales_order_line_number, csod.doo_order_number doo_order_number, to_char(csod.doo_line_number) doo_line_number, csod.sales_order_shipment_number sales_order_shipment_number, csod.receipt_advice_number receipt_advice_number, hcab.cust_account_id bill_cust_account_id, hcas.cust_account_id ship_cust_account_id, hcab.account_number bill_cust_account_number, hcas.account_number ship_cust_account_number, csod.bill_to_site_use_id bill_to_site_use_id, dfla.ship_to_site_use_id ship_to_site_use_id, hcasab.customer_category_code bill_cust_cat_code, hcasas.customer_category_code ship_cust_cat_code, upper(hcab.customer_class_code) bill_customer_class_code, upper(hcas.customer_class_code) ship_customer_class_code, hpb.party_id bill_cust_party_id, hps.party_id ship_cust_party_id, hpb.party_number bill_cust_party_number, hps.party_number ship_cust_party_number, hcsuab.site_use_id bill_uses_site_use_id, hcsuas.site_use_id ship_uses_site_use_id, hcsuab.site_use_code bill_uses_site_use_code, hcsuas.site_use_code ship_uses_site_use_code, fl.meaning doo_order_type, dfla.line_type_code || '-' || dfla.category_code doo_line_type_code, csod.doo_order_header_id doo_order_header_id, gcc.segment1 segment1, gcc.segment2 segment2, gcc.segment3 segment3, gcc.segment4 segment4, gcc.segment5 segment5, gcc.segment6 segment6, gcc.segment7 segment7, gcc.segment8 segment8, gcc.segment9 segment9, gcc.segment10 segment10, csod.ship_to_party_id, hcab.party_id bill_to_party_id, csod.ship_to_party_site_id, hcasab.party_site_id bill_to_party_site_id, csod.sold_to_party_id, hpss.attribute_category ship_party_site_attr_cat, hpss.attribute1 ship_party_site_attr_1, hpss.attribute2 ship_party_site_attr_2, hpss.attribute3 ship_party_site_attr_3, hpss.attribute4 ship_party_site_attr_4, hpss.attribute5 ship_party_site_attr_5, hpss.attribute6 ship_party_site_attr_6, hpss.attribute7 ship_party_site_attr_7, hpss.attribute8 ship_party_site_attr_8, hpss.attribute9 ship_party_site_attr_9, hpss.attribute10 ship_party_site_attr_10, hpss.attribute11 ship_party_site_attr_11, hpss.attribute12 ship_party_site_attr_12, hpss.attribute13 ship_party_site_attr_13, hpss.attribute14 ship_party_site_attr_14, hpss.attribute15 ship_party_site_attr_15, hpss.attribute16 ship_party_site_attr_16, hpss.attribute17 ship_party_site_attr_17, hpss.attribute18 ship_party_site_attr_18, hpss.attribute19 ship_party_site_attr_19, hpss.attribute20 ship_party_site_attr_20, hpss.attribute21 ship_party_site_attr_21, hpss.attribute22 ship_party_site_attr_22, hpss.attribute23 ship_party_site_attr_23, hpss.attribute24 ship_party_site_attr_24, hpss.attribute25 ship_party_site_attr_25, hpss.attribute26 ship_party_site_attr_26, hpss.attribute27 ship_party_site_attr_27, hpss.attribute28 ship_party_site_attr_28, hpss.attribute29 ship_party_site_attr_29, hpss.attribute30 ship_party_site_attr_30, hpss.attribute_number1 ship_party_site_attr_n_1, hpss.attribute_number2 ship_party_site_attr_n_2, hpss.attribute_number3 ship_party_site_attr_n_3, hpss.attribute_number4 ship_party_site_attr_n_4, hpss.attribute_number5 ship_party_site_attr_n_5, hpss.attribute_number6 ship_party_site_attr_n_6, hpss.attribute_number7 ship_party_site_attr_n_7, hpss.attribute_number8 ship_party_site_attr_n_8, hpss.attribute_number9 ship_party_site_attr_n_9, hpss.attribute_number10 ship_party_site_attr_n_10, hpss.attribute_number11 ship_party_site_attr_n_11, hpss.attribute_number12 ship_party_site_attr_n_12, hpss.attribute_date1 ship_party_site_attr_d_1, hpss.attribute_date2 ship_party_site_attr_d_2, hpss.attribute_date3 ship_party_site_attr_d_3, hpss.attribute_date4 ship_party_site_attr_d_4, hpss.attribute_date5 ship_party_site_attr_d_5, hpss.attribute_date6 ship_party_site_attr_d_6, hpss.attribute_date7 ship_party_site_attr_d_7, hpss.attribute_date8 ship_party_site_attr_d_8, hpss.attribute_date9 ship_party_site_attr_d_9, hpss.attribute_date10 ship_party_site_attr_d_10, hpss.attribute_date11 ship_party_site_attr_d_11, hpss.attribute_date12 ship_party_site_attr_d_12, hpsb.attribute_category bill_party_site_attr_cat, hpsb.attribute1 bill_party_site_attr_1, hpsb.attribute2 bill_party_site_attr_2, hpsb.attribute3 bill_party_site_attr_3, hpsb.attribute4 bill_party_site_attr_4, hpsb.attribute5 bill_party_site_attr_5, hpsb.attribute6 bill_party_site_attr_6, hpsb.attribute7 bill_party_site_attr_7, hpsb.attribute8 bill_party_site_attr_8, hpsb.attribute9 bill_party_site_attr_9, hpsb.attribute10 bill_party_site_attr_10, hpsb.attribute11 bill_party_site_attr_11, hpsb.attribute12 bill_party_site_attr_12, hpsb.attribute13 bill_party_site_attr_13, hpsb.attribute14 bill_party_site_attr_14, hpsb.attribute15 bill_party_site_attr_15, hpsb.attribute16 bill_party_site_attr_16, hpsb.attribute17 bill_party_site_attr_17, hpsb.attribute18 bill_party_site_attr_18, hpsb.attribute19 bill_party_site_attr_19, hpsb.attribute20 bill_party_site_attr_20, hpsb.attribute21 bill_party_site_attr_21, hpsb.attribute22 bill_party_site_attr_22, hpsb.attribute23 bill_party_site_attr_23, hpsb.attribute24 bill_party_site_attr_24, hpsb.attribute25 bill_party_site_attr_25, hpsb.attribute26 bill_party_site_attr_26, hpsb.attribute27 bill_party_site_attr_27, hpsb.attribute28 bill_party_site_attr_28, hpsb.attribute29 bill_party_site_attr_29, hpsb.attribute30 bill_party_site_attr_30, hpsb.attribute_number1 bill_party_site_attr_n_1, hpsb.attribute_number2 bill_party_site_attr_n_2, hpsb.attribute_number3 bill_party_site_attr_n_3, hpsb.attribute_number4 bill_party_site_attr_n_4, hpsb.attribute_number5 bill_party_site_attr_n_5, hpsb.attribute_number6 bill_party_site_attr_n_6, hpsb.attribute_number7 bill_party_site_attr_n_7, hpsb.attribute_number8 bill_party_site_attr_n_8, hpsb.attribute_number9 bill_party_site_attr_n_9, hpsb.attribute_number10 bill_party_site_attr_n_10, hpsb.attribute_number11 bill_party_site_attr_n_11, hpsb.attribute_number12 bill_party_site_attr_n_12, hpsb.attribute_date1 bill_party_site_attr_d_1, hpsb.attribute_date2 bill_party_site_attr_d_2, hpsb.attribute_date3 bill_party_site_attr_d_3, hpsb.attribute_date4 bill_party_site_attr_d_4, hpsb.attribute_date5 bill_party_site_attr_d_5, hpsb.attribute_date6 bill_party_site_attr_d_6, hpsb.attribute_date7 bill_party_site_attr_d_7, hpsb.attribute_date8 bill_party_site_attr_d_8, hpsb.attribute_date9 bill_party_site_attr_d_9, hpsb.attribute_date10 bill_party_site_attr_d_10, hpsb.attribute_date11 bill_party_site_attr_d_11, hpsb.attribute_date12 bill_party_site_attr_d_12, hcasas.attribute_category ship_cust_site_attr_cat, hcasas.attribute1 ship_cust_site_attr_1, hcasas.attribute2 ship_cust_site_attr_2, hcasas.attribute3 ship_cust_site_attr_3, hcasas.attribute4 ship_cust_site_attr_4, hcasas.attribute5 ship_cust_site_attr_5, hcasas.attribute6 ship_cust_site_attr_6, hcasas.attribute7 ship_cust_site_attr_7, hcasas.attribute8 ship_cust_site_attr_8, hcasas.attribute9 ship_cust_site_attr_9, hcasas.attribute10 ship_cust_site_attr_10, hcasas.attribute11 ship_cust_site_attr_11, hcasas.attribute12 ship_cust_site_attr_12, hcasas.attribute13 ship_cust_site_attr_13, hcasas.attribute14 ship_cust_site_attr_14, hcasas.attribute15 ship_cust_site_attr_15, hcasas.attribute16 ship_cust_site_attr_16, hcasas.attribute17 ship_cust_site_attr_17, hcasas.attribute18 ship_cust_site_attr_18, hcasas.attribute19 ship_cust_site_attr_19, hcasas.attribute20 ship_cust_site_attr_20, hcasas.attribute21 ship_cust_site_attr_21, hcasas.attribute22 ship_cust_site_attr_22, hcasas.attribute23 ship_cust_site_attr_23, hcasas.attribute24 ship_cust_site_attr_24, hcasas.attribute25 ship_cust_site_attr_25, hcasas.attribute26 ship_cust_site_attr_26, hcasas.attribute27 ship_cust_site_attr_27, hcasas.attribute28 ship_cust_site_attr_28, hcasas.attribute29 ship_cust_site_attr_29, hcasas.attribute30 ship_cust_site_attr_30, hcasas.attribute_number1 ship_cust_site_attr_n_1, hcasas.attribute_number2 ship_cust_site_attr_n_2, hcasas.attribute_number3 ship_cust_site_attr_n_3, hcasas.attribute_number4 ship_cust_site_attr_n_4, hcasas.attribute_number5 ship_cust_site_attr_n_5, hcasas.attribute_number6 ship_cust_site_attr_n_6, hcasas.attribute_number7 ship_cust_site_attr_n_7, hcasas.attribute_number8 ship_cust_site_attr_n_8, hcasas.attribute_number9 ship_cust_site_attr_n_9, hcasas.attribute_number10 ship_cust_site_attr_n_10, hcasas.attribute_number11 ship_cust_site_attr_n_11, hcasas.attribute_number12 ship_cust_site_attr_n_12, hcasas.attribute_date1 ship_cust_site_attr_d_1, hcasas.attribute_date2 ship_cust_site_attr_d_2, hcasas.attribute_date3 ship_cust_site_attr_d_3, hcasas.attribute_date4 ship_cust_site_attr_d_4, hcasas.attribute_date5 ship_cust_site_attr_d_5, hcasas.attribute_date6 ship_cust_site_attr_d_6, hcasas.attribute_date7 ship_cust_site_attr_d_7, hcasas.attribute_date8 ship_cust_site_attr_d_8, hcasas.attribute_date9 ship_cust_site_attr_d_9, hcasas.attribute_date10 ship_cust_site_attr_d_10, hcasas.attribute_date11 ship_cust_site_attr_d_11, hcasas.attribute_date12 ship_cust_site_attr_d_12, hcasab.attribute_category bill_cust_site_attr_cat, hcasab.attribute1 bill_cust_site_attr_1, hcasab.attribute2 bill_cust_site_attr_2, hcasab.attribute3 bill_cust_site_attr_3, hcasab.attribute4 bill_cust_site_attr_4, hcasab.attribute5 bill_cust_site_attr_5, hcasab.attribute6 bill_cust_site_attr_6, hcasab.attribute7 bill_cust_site_attr_7, hcasab.attribute8 bill_cust_site_attr_8, hcasab.attribute9 bill_cust_site_attr_9, hcasab.attribute10 bill_cust_site_attr_10, hcasab.attribute11 bill_cust_site_attr_11, hcasab.attribute12 bill_cust_site_attr_12, hcasab.attribute13 bill_cust_site_attr_13, hcasab.attribute14 bill_cust_site_attr_14, hcasab.attribute15 bill_cust_site_attr_15, hcasab.attribute16 bill_cust_site_attr_16, hcasab.attribute17 bill_cust_site_attr_17, hcasab.attribute18 bill_cust_site_attr_18, hcasab.attribute19 bill_cust_site_attr_19, hcasab.attribute20 bill_cust_site_attr_20, hcasab.attribute21 bill_cust_site_attr_21, hcasab.attribute22 bill_cust_site_attr_22, hcasab.attribute23 bill_cust_site_attr_23, hcasab.attribute24 bill_cust_site_attr_24, hcasab.attribute25 bill_cust_site_attr_25, hcasab.attribute26 bill_cust_site_attr_26, hcasab.attribute27 bill_cust_site_attr_27, hcasab.attribute28 bill_cust_site_attr_28, hcasab.attribute29 bill_cust_site_attr_29, hcasab.attribute30 bill_cust_site_attr_30, hcasab.attribute_number1 bill_cust_site_attr_n_1, hcasab.attribute_number2 bill_cust_site_attr_n_2, hcasab.attribute_number3 bill_cust_site_attr_n_3, hcasab.attribute_number4 bill_cust_site_attr_n_4, hcasab.attribute_number5 bill_cust_site_attr_n_5, hcasab.attribute_number6 bill_cust_site_attr_n_6, hcasab.attribute_number7 bill_cust_site_attr_n_7, hcasab.attribute_number8 bill_cust_site_attr_n_8, hcasab.attribute_number9 bill_cust_site_attr_n_9, hcasab.attribute_number10 bill_cust_site_attr_n_10, hcasab.attribute_number11 bill_cust_site_attr_n_11, hcasab.attribute_number12 bill_cust_site_attr_n_12, hcasab.attribute_date1 bill_cust_site_attr_d_1, hcasab.attribute_date2 bill_cust_site_attr_d_2, hcasab.attribute_date3 bill_cust_site_attr_d_3, hcasab.attribute_date4 bill_cust_site_attr_d_4, hcasab.attribute_date5 bill_cust_site_attr_d_5, hcasab.attribute_date6 bill_cust_site_attr_d_6, hcasab.attribute_date7 bill_cust_site_attr_d_7, hcasab.attribute_date8 bill_cust_site_attr_d_8, hcasab.attribute_date9 bill_cust_site_attr_d_9, hcasab.attribute_date10 bill_cust_site_attr_d_10, hcasab.attribute_date11 bill_cust_site_attr_d_11, hcasab.attribute_date12 bill_cust_site_attr_d_12 FROM cst_sales_order_details csod, doo_fulfill_lines_all dfla, doo_headers_all dha, (SELECT lookup_code, meaning FROM fnd_lookups WHERE lookup_type = 'ORA_DOO_ORDER_TYPES') fl, hz_cust_site_uses_all hcsuab, hz_cust_acct_sites_all hcasab, hz_cust_accounts hcab, hz_parties hpb, ar_ref_accounts_all arab, gl_code_combinations gcc, hz_cust_site_uses_all hcsuas, hz_cust_acct_sites_all hcasas, hz_cust_accounts hcas, hz_parties hps, hz_party_sites hpss, hz_party_sites hpsb WHERE csod.external_system_reference != 'NONFUSION' AND csod.external_system_ref_id = to_char(dfla.fulfill_line_id) AND csod.doo_order_header_id = dha.header_id AND dha.header_id = dfla.header_id AND dha.order_type_code = fl.lookup_code (+) AND dfla.bill_to_site_use_id = hcsuab.site_use_id AND hcsuab.cust_acct_site_id = hcasab.cust_acct_site_id AND hcasab.cust_account_id (+) = hcab.cust_account_id AND hcab.party_id = hpb.party_id AND hcsuab.site_use_id = arab.source_ref_account_id (+) AND arab.rev_ccid = gcc.code_combination_id (+) AND dfla.ship_to_site_use_id = hcsuas.site_use_id (+) AND hcsuas.cust_acct_site_id = hcasas.cust_acct_site_id (+) AND hcasas.cust_account_id = hcas.cust_account_id (+) AND hcas.party_id = hps.party_id (+) AND csod.ship_to_party_site_id = hpss.party_site_id (+) AND hcasab.party_site_id = hpsb.party_site_id (+) UNION ALL SELECT DISTINCT csod.selling_legal_entity_id selling_legal_entity_id, csod.selling_org_id selling_org_id, csod.external_system_ref_id external_system_ref_id, csod.customer_id customer_id, csod.ship_to_customer_id ship_to_customer_id, csod.external_system_reference external_system_reference, substr(csod.external_system_ref_id, 0, instr(csod.external_system_ref_id, '^') - 1) source_sales_order_number, substr(csod.external_system_ref_id, instr(csod.external_system_ref_id, '^', 1, 1) + 1, instr(csod.external_system_ref_id, '^', 1, 2) - instr(csod.external_system_ref_id, '^', 1, 1) - 1) source_sales_order_line_number, csod.doo_order_number doo_order_number, to_char(csod.doo_line_number) doo_line_number, csod.sales_order_shipment_number sales_order_shipment_number, csod.receipt_advice_number receipt_advice_number, hcab.cust_account_id bill_cust_account_id, NULL ship_cust_account_id, hcab.account_number bill_cust_account_number, NULL ship_cust_account_number, csod.bill_to_site_use_id, - 1 ship_to_site_use_id, hpb.category_code bill_cust_cat_code, NULL ship_cust_cat_code, upper(hcab.customer_class_code) bill_customer_class_code, NULL ship_customer_class_code, hpb.party_id bill_cust_party_id, NULL ship_cust_party_id, hpb.party_number bill_cust_party_number, NULL ship_cust_party_number, - 1 bill_uses_site_use_id, - 1 ship_uses_site_use_id, CAST(NULL AS VARCHAR2(30)) bill_uses_site_use_code, CAST(NULL AS VARCHAR2(30)) ship_uses_site_use_code, CAST(NULL AS VARCHAR2(30)) doo_order_type, CAST(NULL AS VARCHAR2(61)) doo_line_type_type, CAST(NULL AS NUMBER(18)) doo_order_header_id, 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, csod.ship_to_party_id, csod.bill_to_customer_id bill_to_party_id, csod.ship_to_party_site_id, hcasab.party_site_id bill_to_party_site_id, csod.sold_to_party_id, hpss.attribute_category ship_party_site_attr_cat, hpss.attribute1 ship_party_site_attr_1, hpss.attribute2 ship_party_site_attr_2, hpss.attribute3 ship_party_site_attr_3, hpss.attribute4 ship_party_site_attr_4, hpss.attribute5 ship_party_site_attr_5, hpss.attribute6 ship_party_site_attr_6, hpss.attribute7 ship_party_site_attr_7, hpss.attribute8 ship_party_site_attr_8, hpss.attribute9 ship_party_site_attr_9, hpss.attribute10 ship_party_site_attr_10, hpss.attribute11 ship_party_site_attr_11, hpss.attribute12 ship_party_site_attr_12, hpss.attribute13 ship_party_site_attr_13, hpss.attribute14 ship_party_site_attr_14, hpss.attribute15 ship_party_site_attr_15, hpss.attribute16 ship_party_site_attr_16, hpss.attribute17 ship_party_site_attr_17, hpss.attribute18 ship_party_site_attr_18, hpss.attribute19 ship_party_site_attr_19, hpss.attribute20 ship_party_site_attr_20, hpss.attribute21 ship_party_site_attr_21, hpss.attribute22 ship_party_site_attr_22, hpss.attribute23 ship_party_site_attr_23, hpss.attribute24 ship_party_site_attr_24, hpss.attribute25 ship_party_site_attr_25, hpss.attribute26 ship_party_site_attr_26, hpss.attribute27 ship_party_site_attr_27, hpss.attribute28 ship_party_site_attr_28, hpss.attribute29 ship_party_site_attr_29, hpss.attribute30 ship_party_site_attr_30, hpss.attribute_number1 ship_party_site_attr_n_1, hpss.attribute_number2 ship_party_site_attr_n_2, hpss.attribute_number3 ship_party_site_attr_n_3, hpss.attribute_number4 ship_party_site_attr_n_4, hpss.attribute_number5 ship_party_site_attr_n_5, hpss.attribute_number6 ship_party_site_attr_n_6, hpss.attribute_number7 ship_party_site_attr_n_7, hpss.attribute_number8 ship_party_site_attr_n_8, hpss.attribute_number9 ship_party_site_attr_n_9, hpss.attribute_number10 ship_party_site_attr_n_10, hpss.attribute_number11 ship_party_site_attr_n_11, hpss.attribute_number12 ship_party_site_attr_n_12, hpss.attribute_date1 ship_party_site_attr_d_1, hpss.attribute_date2 ship_party_site_attr_d_2, hpss.attribute_date3 ship_party_site_attr_d_3, hpss.attribute_date4 ship_party_site_attr_d_4, hpss.attribute_date5 ship_party_site_attr_d_5, hpss.attribute_date6 ship_party_site_attr_d_6, hpss.attribute_date7 ship_party_site_attr_d_7, hpss.attribute_date8 ship_party_site_attr_d_8, hpss.attribute_date9 ship_party_site_attr_d_9, hpss.attribute_date10 ship_party_site_attr_d_10, hpss.attribute_date11 ship_party_site_attr_d_11, hpss.attribute_date12 ship_party_site_attr_d_12, hpsb.attribute_category bill_party_site_attr_cat, hpsb.attribute1 bill_party_site_attr_1, hpsb.attribute2 bill_party_site_attr_2, hpsb.attribute3 bill_party_site_attr_3, hpsb.attribute4 bill_party_site_attr_4, hpsb.attribute5 bill_party_site_attr_5, hpsb.attribute6 bill_party_site_attr_6, hpsb.attribute7 bill_party_site_attr_7, hpsb.attribute8 bill_party_site_attr_8, hpsb.attribute9 bill_party_site_attr_9, hpsb.attribute10 bill_party_site_attr_10, hpsb.attribute11 bill_party_site_attr_11, hpsb.attribute12 bill_party_site_attr_12, hpsb.attribute13 bill_party_site_attr_13, hpsb.attribute14 bill_party_site_attr_14, hpsb.attribute15 bill_party_site_attr_15, hpsb.attribute16 bill_party_site_attr_16, hpsb.attribute17 bill_party_site_attr_17, hpsb.attribute18 bill_party_site_attr_18, hpsb.attribute19 bill_party_site_attr_19, hpsb.attribute20 bill_party_site_attr_20, hpsb.attribute21 bill_party_site_attr_21, hpsb.attribute22 bill_party_site_attr_22, hpsb.attribute23 bill_party_site_attr_23, hpsb.attribute24 bill_party_site_attr_24, hpsb.attribute25 bill_party_site_attr_25, hpsb.attribute26 bill_party_site_attr_26, hpsb.attribute27 bill_party_site_attr_27, hpsb.attribute28 bill_party_site_attr_28, hpsb.attribute29 bill_party_site_attr_29, hpsb.attribute30 bill_party_site_attr_30, hpsb.attribute_number1 bill_party_site_attr_n_1, hpsb.attribute_number2 bill_party_site_attr_n_2, hpsb.attribute_number3 bill_party_site_attr_n_3, hpsb.attribute_number4 bill_party_site_attr_n_4, hpsb.attribute_number5 bill_party_site_attr_n_5, hpsb.attribute_number6 bill_party_site_attr_n_6, hpsb.attribute_number7 bill_party_site_attr_n_7, hpsb.attribute_number8 bill_party_site_attr_n_8, hpsb.attribute_number9 bill_party_site_attr_n_9, hpsb.attribute_number10 bill_party_site_attr_n_10, hpsb.attribute_number11 bill_party_site_attr_n_11, hpsb.attribute_number12 bill_party_site_attr_n_12, hpsb.attribute_date1 bill_party_site_attr_d_1, hpsb.attribute_date2 bill_party_site_attr_d_2, hpsb.attribute_date3 bill_party_site_attr_d_3, hpsb.attribute_date4 bill_party_site_attr_d_4, hpsb.attribute_date5 bill_party_site_attr_d_5, hpsb.attribute_date6 bill_party_site_attr_d_6, hpsb.attribute_date7 bill_party_site_attr_d_7, hpsb.attribute_date8 bill_party_site_attr_d_8, hpsb.attribute_date9 bill_party_site_attr_d_9, hpsb.attribute_date10 bill_party_site_attr_d_10, hpsb.attribute_date11 bill_party_site_attr_d_11, hpsb.attribute_date12 bill_party_site_attr_d_12, NULL ship_cust_site_attr_cat, NULL ship_cust_site_attr_1, NULL ship_cust_site_attr_2, NULL ship_cust_site_attr_3, NULL ship_cust_site_attr_4, NULL ship_cust_site_attr_5, NULL ship_cust_site_attr_6, NULL ship_cust_site_attr_7, NULL ship_cust_site_attr_8, NULL ship_cust_site_attr_9, NULL ship_cust_site_attr_10, NULL ship_cust_site_attr_11, NULL ship_cust_site_attr_12, NULL ship_cust_site_attr_13, NULL ship_cust_site_attr_14, NULL ship_cust_site_attr_15, NULL ship_cust_site_attr_16, NULL ship_cust_site_attr_17, NULL ship_cust_site_attr_18, NULL ship_cust_site_attr_19, NULL ship_cust_site_attr_20, NULL ship_cust_site_attr_21, NULL ship_cust_site_attr_22, NULL ship_cust_site_attr_23, NULL ship_cust_site_attr_24, NULL ship_cust_site_attr_25, NULL ship_cust_site_attr_26, NULL ship_cust_site_attr_27, NULL ship_cust_site_attr_28, NULL ship_cust_site_attr_29, NULL ship_cust_site_attr_30, NULL ship_cust_site_attr_n_1, NULL ship_cust_site_attr_n_2, NULL ship_cust_site_attr_n_3, NULL ship_cust_site_attr_n_4, NULL ship_cust_site_attr_n_5, NULL ship_cust_site_attr_n_6, NULL ship_cust_site_attr_n_7, NULL ship_cust_site_attr_n_8, NULL ship_cust_site_attr_n_9, NULL ship_cust_site_attr_n_10, NULL ship_cust_site_attr_n_11, NULL ship_cust_site_attr_n_12, NULL ship_cust_site_attr_d_1, NULL ship_cust_site_attr_d_2, NULL ship_cust_site_attr_d_3, NULL ship_cust_site_attr_d_4, NULL ship_cust_site_attr_d_5, NULL ship_cust_site_attr_d_6, NULL ship_cust_site_attr_d_7, NULL ship_cust_site_attr_d_8, NULL ship_cust_site_attr_d_9, NULL ship_cust_site_attr_d_10, NULL ship_cust_site_attr_d_11, NULL ship_cust_site_attr_d_12, hcasab.attribute_category bill_cust_site_attr_cat, hcasab.attribute1 bill_cust_site_attr_1, hcasab.attribute2 bill_cust_site_attr_2, hcasab.attribute3 bill_cust_site_attr_3, hcasab.attribute4 bill_cust_site_attr_4, hcasab.attribute5 bill_cust_site_attr_5, hcasab.attribute6 bill_cust_site_attr_6, hcasab.attribute7 bill_cust_site_attr_7, hcasab.attribute8 bill_cust_site_attr_8, hcasab.attribute9 bill_cust_site_attr_9, hcasab.attribute10 bill_cust_site_attr_10, hcasab.attribute11 bill_cust_site_attr_11, hcasab.attribute12 bill_cust_site_attr_12, hcasab.attribute13 bill_cust_site_attr_13, hcasab.attribute14 bill_cust_site_attr_14, hcasab.attribute15 bill_cust_site_attr_15, hcasab.attribute16 bill_cust_site_attr_16, hcasab.attribute17 bill_cust_site_attr_17, hcasab.attribute18 bill_cust_site_attr_18, hcasab.attribute19 bill_cust_site_attr_19, hcasab.attribute20 bill_cust_site_attr_20, hcasab.attribute21 bill_cust_site_attr_21, hcasab.attribute22 bill_cust_site_attr_22, hcasab.attribute23 bill_cust_site_attr_23, hcasab.attribute24 bill_cust_site_attr_24, hcasab.attribute25 bill_cust_site_attr_25, hcasab.attribute26 bill_cust_site_attr_26, hcasab.attribute27 bill_cust_site_attr_27, hcasab.attribute28 bill_cust_site_attr_28, hcasab.attribute29 bill_cust_site_attr_29, hcasab.attribute30 bill_cust_site_attr_30, hcasab.attribute_number1 bill_cust_site_attr_n_1, hcasab.attribute_number2 bill_cust_site_attr_n_2, hcasab.attribute_number3 bill_cust_site_attr_n_3, hcasab.attribute_number4 bill_cust_site_attr_n_4, hcasab.attribute_number5 bill_cust_site_attr_n_5, hcasab.attribute_number6 bill_cust_site_attr_n_6, hcasab.attribute_number7 bill_cust_site_attr_n_7, hcasab.attribute_number8 bill_cust_site_attr_n_8, hcasab.attribute_number9 bill_cust_site_attr_n_9, hcasab.attribute_number10 bill_cust_site_attr_n_10, hcasab.attribute_number11 bill_cust_site_attr_n_11, hcasab.attribute_number12 bill_cust_site_attr_n_12, hcasab.attribute_date1 bill_cust_site_attr_d_1, hcasab.attribute_date2 bill_cust_site_attr_d_2, hcasab.attribute_date3 bill_cust_site_attr_d_3, hcasab.attribute_date4 bill_cust_site_attr_d_4, hcasab.attribute_date5 bill_cust_site_attr_d_5, hcasab.attribute_date6 bill_cust_site_attr_d_6, hcasab.attribute_date7 bill_cust_site_attr_d_7, hcasab.attribute_date8 bill_cust_site_attr_d_8, hcasab.attribute_date9 bill_cust_site_attr_d_9, hcasab.attribute_date10 bill_cust_site_attr_d_10, hcasab.attribute_date11 bill_cust_site_attr_d_11, hcasab.attribute_date12 bill_cust_site_attr_d_12 FROM cst_sales_order_details csod, hz_cust_acct_sites_all hcasab, hz_cust_accounts hcab, hz_parties hpb, hz_party_sites hpss, hz_party_sites hpsb WHERE csod.external_system_reference = 'NONFUSION' AND hcab.cust_account_id (+) = csod.customer_account_id AND hcasab.cust_account_id (+) = hcab.cust_account_id AND csod.bill_to_customer_id = hcab.party_id (+) AND csod.bill_to_customer_id = hpb.party_id (+) AND csod.ship_to_party_site_id = hpss.party_site_id (+) AND hcasab.party_site_id = hpsb.party_site_id (+)