CSE_SO_DETAILS_V

Details

• Schema: FUSION

• Object owner: CSE

• Object type: VIEW

Columns

Name
ORDER_ID ORDER_NUMBER LINE_ID LINE_NUMBER LINE_CATEGORY_CODE SHIP_TO_PARTY_ID SHIP_TO_PARTY_NUMBER SHIP_TO_PARTY_NAME SHIP_TO_PARTY_SITE_ID SHIP_TO_LOCATION_ID BILL_TO_PARTY_ID BILL_TO_CUST_ACCT_ID

Query

SQL_Statement

select dha.source_order_id order_id, dha.source_order_number order_number, dla.source_line_id line_id, dla.source_line_number line_number, dla.category_code line_category_code, doa_ship.party_id ship_to_party_id, hp_ship.party_number ship_to_party_number, hp_ship.party_name ship_to_party_name, doa_ship.party_site_id ship_to_party_site_id, hps.location_id ship_to_location_id, doa_bill.party_id bill_to_party_id, doa_bill.cust_acct_id bill_to_cust_acct_id from doo_headers_all dha, doo_fulfill_lines_all dla, doo_order_addresses doa_ship, doo_order_addresses doa_bill, hz_parties hp_ship, hz_party_sites hps where dla.header_id = dha.header_id and dha.status_code = 'DOO_REFERENCE' and dha.reference_header_id is not null and doa_ship.header_id = dha.header_id and doa_ship.address_use_type = 'SHIP_TO' and doa_bill.header_id = dha.header_id and doa_bill.address_use_type = 'BILL_TO' and hp_ship.party_id = doa_ship.party_id and hps.party_site_id = doa_ship.party_site_id