VIEW: APPS.POR_RCV_INTERNAL_ITEMS_V

Source

View Text - Preformatted

SELECT SYSDATE RECEIPT_DATE, PORL.TO_PERSON_ID REQUESTOR_ID, OSH.HEADER_ID PO_HEADER_ID, NULL, TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), PORL.DESTINATION_ORGANIZATION_ID TO_ORGANIZATION_ID, PORL.ITEM_ID ITEM_ID, PORL.UNIT_MEAS_LOOKUP_CODE PRIMARY_UOM, MUM.UOM_CLASS UOM_CLASS, PORL.QUANTITY_DELIVERED, PORL.QUANTITY - NVL(PORL.QUANTITY_CANCELLED, 0) - NVL(PORL.QUANTITY_DELIVERED, 0) EXPECTED_RECEIPT_QTY, PORL.ITEM_DESCRIPTION, PORL.DELIVER_TO_LOCATION_ID SHIP_TO_LOCATION_ID, TO_NUMBER(NULL), OOD.NAME, TO_NUMBER(NULL), NULL, PORL.NEED_BY_DATE NEED_BY_DATE, TO_DATE(NULL), PORL.NEED_BY_DATE EXPECTED_RECEIPT_DATE, PORL.QUANTITY ORDERED_QTY, PORL.UNIT_MEAS_LOOKUP_CODE ORDERED_UOM, TO_NUMBER(NULL), PORL.DELIVER_TO_LOCATION_ID, TO_NUMBER(NULL), TO_NUMBER(NULL), NULL, TO_CHAR(OSH.ORDER_NUMBER) PO_NUM_REL_NUM, OSH.HEADER_ID ORDER_ID, OSH.ORDER_NUMBER, PORL.REQUISITION_LINE_ID, PORH.REQUISITION_HEADER_ID, PORH.SEGMENT1, 'REQ', PORL.MANUFACTURER_PART_NUMBER, NULL, PORL.DESTINATION_TYPE_CODE, 0, PORL.MATCHING_BASIS FROM MTL_UNITS_OF_MEASURE MUM, HR_ALL_ORGANIZATION_UNITS_TL OOD, PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL, OE_ORDER_HEADERS_ALL OSH, PO_SYSTEM_PARAMETERS POSP WHERE PORL.QUANTITY - NVL(PORL.QUANTITY_CANCELLED, 0) - NVL(PORL.QUANTITY_DELIVERED, 0) > 0 AND PORL.SOURCE_TYPE_CODE = 'INVENTORY' AND OSH.ORDER_SOURCE_ID = POSP.ORDER_SOURCE_ID AND OSH.ORIG_SYS_DOCUMENT_REF = PORH.SEGMENT1 AND OSH.SOURCE_DOCUMENT_ID = PORH.REQUISITION_HEADER_ID AND PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID AND MUM.UNIT_OF_MEASURE = PORL.UNIT_MEAS_LOOKUP_CODE AND OOD.ORGANIZATION_ID = PORL.SOURCE_ORGANIZATION_ID AND OOD.LANGUAGE = USERENV('LANG') AND EXISTS (SELECT 1 FROM RCV_SHIPMENT_LINES RSL WHERE RSL.REQUISITION_LINE_ID = PORL.REQUISITION_LINE_ID AND RSL.ROUTING_HEADER_ID = 3)

View Text - HTML Formatted

SELECT SYSDATE RECEIPT_DATE
, PORL.TO_PERSON_ID REQUESTOR_ID
, OSH.HEADER_ID PO_HEADER_ID
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, PORL.DESTINATION_ORGANIZATION_ID TO_ORGANIZATION_ID
, PORL.ITEM_ID ITEM_ID
, PORL.UNIT_MEAS_LOOKUP_CODE PRIMARY_UOM
, MUM.UOM_CLASS UOM_CLASS
, PORL.QUANTITY_DELIVERED
, PORL.QUANTITY - NVL(PORL.QUANTITY_CANCELLED
, 0) - NVL(PORL.QUANTITY_DELIVERED
, 0) EXPECTED_RECEIPT_QTY
, PORL.ITEM_DESCRIPTION
, PORL.DELIVER_TO_LOCATION_ID SHIP_TO_LOCATION_ID
, TO_NUMBER(NULL)
, OOD.NAME
, TO_NUMBER(NULL)
, NULL
, PORL.NEED_BY_DATE NEED_BY_DATE
, TO_DATE(NULL)
, PORL.NEED_BY_DATE EXPECTED_RECEIPT_DATE
, PORL.QUANTITY ORDERED_QTY
, PORL.UNIT_MEAS_LOOKUP_CODE ORDERED_UOM
, TO_NUMBER(NULL)
, PORL.DELIVER_TO_LOCATION_ID
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, TO_CHAR(OSH.ORDER_NUMBER) PO_NUM_REL_NUM
, OSH.HEADER_ID ORDER_ID
, OSH.ORDER_NUMBER
, PORL.REQUISITION_LINE_ID
, PORH.REQUISITION_HEADER_ID
, PORH.SEGMENT1
, 'REQ'
, PORL.MANUFACTURER_PART_NUMBER
, NULL
, PORL.DESTINATION_TYPE_CODE
, 0
, PORL.MATCHING_BASIS
FROM MTL_UNITS_OF_MEASURE MUM
, HR_ALL_ORGANIZATION_UNITS_TL OOD
, PO_REQUISITION_HEADERS PORH
, PO_REQUISITION_LINES PORL
, OE_ORDER_HEADERS_ALL OSH
, PO_SYSTEM_PARAMETERS POSP
WHERE PORL.QUANTITY - NVL(PORL.QUANTITY_CANCELLED
, 0) - NVL(PORL.QUANTITY_DELIVERED
, 0) > 0
AND PORL.SOURCE_TYPE_CODE = 'INVENTORY'
AND OSH.ORDER_SOURCE_ID = POSP.ORDER_SOURCE_ID
AND OSH.ORIG_SYS_DOCUMENT_REF = PORH.SEGMENT1
AND OSH.SOURCE_DOCUMENT_ID = PORH.REQUISITION_HEADER_ID
AND PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID
AND MUM.UNIT_OF_MEASURE = PORL.UNIT_MEAS_LOOKUP_CODE
AND OOD.ORGANIZATION_ID = PORL.SOURCE_ORGANIZATION_ID
AND OOD.LANGUAGE = USERENV('LANG')
AND EXISTS (SELECT 1
FROM RCV_SHIPMENT_LINES RSL
WHERE RSL.REQUISITION_LINE_ID = PORL.REQUISITION_LINE_ID
AND RSL.ROUTING_HEADER_ID = 3)