CJM_XLA_SR_TRX_V

Details

• Schema: FUSION

• Object owner: CJM

• Object type: VIEW

Columns

Name

DOCUMENT_BATCH_ID DOCUMENT_HEADER_ID DOCUMENT_LINE_ID RECEIVING_TRANSACTION_ID PO_BILL_TO_LOCATION PO_BILL_TO_LOCATION_ID PO_BILL_TO_LOCATION_CITY PO_BILL_TO_LOCATION_COUNTY PO_BILL_TO_LOCATION_COUNTRY PO_BILL_TO_LOCATION_STATE PO_BILL_TO_LOCATION_PROVINCE PO_BILL_TO_LOC_POSTAL_CODE PO_SHIP_TO_LOCATION PO_SHIP_TO_LOCATION_ID PO_SHIP_TO_LOCATION_CITY PO_SHIP_TO_LOCATION_COUNTY PO_SHIP_TO_LOCATION_COUNTRY PO_SHIP_TO_LOCATION_STATE PO_SHIP_TO_LOCATION_PROVINCE PO_SHIP_TO_LOC_POSTAL_CODE BATCH_DATA_SOURCE PO_DATE SUPPLIER_ITEM INVENTORY_ORGANIZATION INVENTORY_ORGANIZATION_ID

Query

SQL_Statement

SELECT cdb.document_batch_id "DOCUMENT_BATCH_ID", cdh.document_header_id "DOCUMENT_HEADER_ID", cdl.document_line_id "DOCUMENT_LINE_ID", cdl.transaction_id "RECEIVING_TRANSACTION_ID", Bill_HRL.location_name "PO_BILL_TO_LOCATION", cdl.bill_to_location_id "PO_BILL_TO_LOCATION_ID", Bill_HRL.TOWN_OR_CITY "PO_BILL_TO_LOCATION_CITY", Bill_HRL.COUNTRY "PO_BILL_TO_LOCATION_COUNTY", Bill_HRL.REGION_1 "PO_BILL_TO_LOCATION_COUNTRY", Bill_HRL.REGION_2 "PO_BILL_TO_LOCATION_STATE", Bill_HRL.REGION_3 "PO_BILL_TO_LOCATION_PROVINCE", Bill_HRL.POSTAL_CODE "PO_BILL_TO_LOC_POSTAL_CODE", Ship_HRL.location_name "PO_SHIP_TO_LOCATION", cdl.ship_to_location_id "PO_SHIP_TO_LOCATION_ID", Ship_HRL.TOWN_OR_CITY "PO_SHIP_TO_LOCATION_CITY", Ship_HRL.COUNTRY "PO_SHIP_TO_LOCATION_COUNTY", Ship_HRL.REGION_1 "PO_SHIP_TO_LOCATION_COUNTRY", Ship_HRL.REGION_2 "PO_SHIP_TO_LOCATION_STATE", Ship_HRL.REGION_3 "PO_SHIP_TO_LOCATION_PROVINCE", Ship_HRL.POSTAL_CODE "PO_SHIP_TO_LOC_POSTAL_CODE", cdb.data_source_code "BATCH_DATA_SOURCE", cdl.po_date "PO_DATE", cdl.tp_item_num "SUPPLIER_ITEM", (SELECT hou.name FROM fusion.HR_ORGANIZATION_UNITS_F_TL hou WHERE hou.organization_id = cdl.inventory_organization_id AND hou.LANGUAGE = USERENV('LANG') AND rownum = 1) "INVENTORY_ORGANIZATION", cdl.inventory_organization_id "INVENTORY_ORGANIZATION_ID" FROM fusion.cjm_document_headers_all cdh, fusion.cjm_document_lines_all cdl, fusion.cjm_document_batches_all cdb, fusion.HR_LOCATIONS_ALL_VL Ship_HRL, fusion.HR_LOCATIONS_ALL_VL Bill_HRL WHERE cdh.document_header_id = cdl.document_header_id AND cdb.document_batch_id = cdl.document_batch_id AND cdl.bill_to_location_id = Bill_HRL.location_id(+) AND cdl.ship_to_location_id = Ship_HRL.location_id(+)