PO_SCO_INTEGRATION_V

Details

• Schema: FUSION

• Object owner: PO

• Object type: VIEW

Columns

Name

SEGMENT1 PO_HEADER_ID DOCUMENT_STATUS AGENT_ID VENDOR_ID VENDOR_SITE_ID VENDOR_SITE_CODE LINE_NUM PO_LINE_ID ITEM_ID ITEM_REVISION SHIPMENT_NUM LINE_LOCATION_ID SCHEDULE_STATUS CARRIER_ID MODE_OF_TRANSPORT REQUESTED_DELIVERY_DATE PROMISED_DELIVERY_DATE PROMISED_SHIP_DATE REQUESTED_SHIP_DATE REQUESTED_DELIVERY_DATE_UTC PROMISED_DELIVERY_DATE_UTC PROMISED_SHIP_DATE_UTC REQUESTED_SHIP_DATE_UTC 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_NUMBER REQUISITION_HEADER_ID REQUISITION_LINE_NUM REQUISITION_LINE_ID REQUISITION_LINE_UOM REQUISITION_LINE_QTY REQUISITION_LINE_DATE REINSTATED_REQ_LINE_NUM REINSTATED_REQ_LINE_ID REINSTATED_REQ_LINE_QTY CHANGE_TYPE_CODE UOM_CODE QUANTITY SECONDARY_UOM_CODE SECONDARY_QUANTITY SHIP_TO_ORGANIZATION_ID BACK_TO_BACK_FLAG CO_SEQUENCE CO_INITIATING_PARTY WORK_ORDER_NUMBER WORK_ORDER_ID WORK_ORDER_OPERATION_ID

Query

SQL_Statement

SELECT POH.SEGMENT1, POH.PO_HEADER_ID, POH.DOCUMENT_STATUS, POH.AGENT_ID, POH.VENDOR_ID, POH.VENDOR_SITE_ID, SS.VENDOR_SITE_CODE, POL.LINE_NUM, POL.PO_LINE_ID, POL.ITEM_ID, POL.ITEM_REVISION, POLL.SHIPMENT_NUM, POLL.LINE_LOCATION_ID, POLL.SCHEDULE_STATUS, 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, PO_PURCHASE_REQUEST_UTIL.GET_UTC_DATE_FOR_VIEW(POLL.NEED_BY_DATE,POLL.SHIP_TO_ORGANIZATION_ID) REQUESTED_DELIVERY_DATE_UTC, PO_PURCHASE_REQUEST_UTIL.GET_UTC_DATE_FOR_VIEW(POLL.PROMISED_DATE,POLL.SHIP_TO_ORGANIZATION_ID) PROMISED_DELIVERY_DATE_UTC, PO_PURCHASE_REQUEST_UTIL.GET_UTC_DATE_FOR_VIEW(POLL.PROMISED_SHIP_DATE,POLL.SHIP_TO_ORGANIZATION_ID) PROMISED_SHIP_DATE_UTC, PO_PURCHASE_REQUEST_UTIL.GET_UTC_DATE_FOR_VIEW(POLL.REQUESTED_SHIP_DATE,POLL.SHIP_TO_ORGANIZATION_ID) REQUESTED_SHIP_DATE_UTC, 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, RH.REQUISITION_NUMBER, RL.REQUISITION_HEADER_ID, RL.LINE_NUMBER REQUISITION_LINE_NUM, RL.REQUISITION_LINE_ID, RL.UOM_CODE REQUISITION_LINE_UOM, RL.QUANTITY REQUISITION_LINE_QTY, RL.NEED_BY_DATE REQUISITION_LINE_DATE, RRL.LINE_NUMBER REINSTATED_REQ_LINE_NUM, RRL.REQUISITION_LINE_ID REINSTATED_REQ_LINE_ID, POLL.SHIPPING_UOM_QUANTITY_CANCELED REINSTATED_REQ_LINE_QTY, 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, POLL.SECONDARY_UOM_CODE, POLL.SECONDARY_QUANTITY, POLL.SHIP_TO_ORGANIZATION_ID, POLL.BACK_TO_BACK_FLAG, POV.CO_SEQUENCE, POV.ORIGINATOR_ROLE CO_INITIATING_PARTY, POLL.WORK_ORDER_NUMBER, POLL.WORK_ORDER_ID, POLL.WORK_ORDER_OPERATION_ID FROM PO_HEADERS_ALL POH,PO_LINES_ALL POL,PO_LINE_LOCATIONS_ALL POLL,PO_DISTRIBUTIONS_ALL POD,POR_REQUISITION_HEADERS_ALL RH,POR_REQUISITION_LINES_ALL RL,POR_REQ_DISTRIBUTIONS_ALL RD,POR_REQUISITION_LINES_ALL RRL,POZ_SUPPLIER_SITES_ALL_M SS,PO_VERSIONS POV 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 = 'SCOTRACK' AND POD.REQ_DISTRIBUTION_ID = RD.DISTRIBUTION_ID AND RD.REQUISITION_LINE_ID = RL.REQUISITION_LINE_ID AND RL.REQUISITION_HEADER_ID = RH.REQUISITION_HEADER_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 (+)