PO_DOO_INTEGRATION_DETAILS_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name

SEGMENT1 PO_HEADER_ID DOCUMENT_STATUS AGENT_ID VENDOR_ID VENDOR_SITE_CODE LINE_NUM PO_LINE_ID ITEM_REVISION SHIPMENT_NUM LINE_LOCATION_ID CARRIER_ID MODE_OF_TRANSPORT REQUESTED_DELIVERY_DATE PROMISED_DELIVERY_DATE PROMISED_SHIP_DATE REQUESTED_SHIP_DATE SERVICE_LEVEL SHIP_TO_CUST_ID CUSTOMER_ITEM CUSTOMER_PO_SCHEDULE_NUMBER ORIGINAL_SHIPMENT_ID SALES_ORDER_NUMBER SALES_ORDER_LINE_NUMBER SALES_ORDER_SCHEDULE_NUMBER REQUISITION_HEADER_ID REQUISITION_LINE_ID REINSTATED_REQ_LINE_NUM REINSTATED_REQ_LINE_ID REINSTATED_REQ_LINE_QUANTITY CHANGE_TYPE_CODE UOM_CODE QUANTITY

Query

SQL_Statement

SELECT POH.SEGMENT1, POH.PO_HEADER_ID, POH.DOCUMENT_STATUS, POH.AGENT_ID, POH.VENDOR_ID, SS.VENDOR_SITE_CODE, POL.LINE_NUM, POL.PO_LINE_ID, POL.ITEM_REVISION, POLL.SHIPMENT_NUM, POLL.LINE_LOCATION_ID, POLL.CARRIER_ID, POLL.MODE_OF_TRANSPORT, POLL.NEED_BY_DATE REQUESTED_DELIVERY_DATE, POLL.PROMISED_DATE PROMISED_DELIVERY_DATE, POLL.PROMISED_SHIP_DATE, POLL.REQUESTED_SHIP_DATE, POLL.SERVICE_LEVEL, POLL.SHIP_TO_CUST_ID, POLL.CUSTOMER_ITEM, POLL.CUSTOMER_PO_SCHEDULE_NUMBER, POLL.ORIGINAL_SHIPMENT_ID, POLL.SALES_ORDER_NUMBER, POLL.SALES_ORDER_LINE_NUMBER, POLL.SALES_ORDER_SCHEDULE_NUMBER, RL.REQUISITION_HEADER_ID, RL.REQUISITION_LINE_ID, RRL.LINE_NUMBER REINSTATED_REQ_LINE_NUM, RRL.REQUISITION_LINE_ID REINSTATED_REQ_LINE_ID, POLL.SHIPPING_UOM_QUANTITY_CANCELED REINSTATED_REQ_LINE_QUANTITY, PO_PURCHASE_REQUEST_UTIL.UPDATE_CHANGE_TYPE_FOR_VIEW(POLL.LINE_LOCATION_ID,POV.CO_SEQUENCE) CHANGE_TYPE_CODE, POLL.SHIPPING_UOM_CODE UOM_CODE, POLL.SHIPPING_UOM_QUANTITY QUANTITY FROM PO_HEADERS_ALL POH,PO_LINES_ALL POL, PO_LINE_LOCATIONS_ALL POLL,PO_DISTRIBUTIONS_ALL POD,POR_REQUISITION_LINES_ALL RL, POR_REQ_DISTRIBUTIONS_ALL RD, POR_REQUISITION_LINES_ALL RRL,POZ_SUPPLIER_SITES_ALL_M SS, PO_VERSIONS POV,PO_LINE_LOCATIONS_ARCHIVE_ALL POA WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID AND POL.PO_LINE_ID = POLL.PO_LINE_ID AND POLL.LINE_LOCATION_ID = POD.LINE_LOCATION_ID AND POH.CURRENT_VERSION_ID = POV.VERSION_ID AND POLL.ORCHESTRATION_CODE = 'DOO_TRACKING' AND POA.LINE_LOCATION_ID = POLL.LINE_LOCATION_ID AND POA.FROM_CO_SEQ = POV.CO_SEQUENCE AND POD.REQ_DISTRIBUTION_ID = RD.DISTRIBUTION_ID AND RD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID(+) AND RL.REQUISITION_HEADER_ID = RRL.REQUISITION_HEADER_ID(+) AND POLL.LINE_LOCATION_ID = RRL.REINSTATE_LINE_LOCATION_ID (+) AND POH.VENDOR_SITE_ID = SS.VENDOR_SITE_ID (+)