VIEW: APPS.POR_RCV_INTERNAL_ITEMS_V

Source

View Text - Preformatted

SELECT SYSDATE RECEIPT_DATE, PORL.TO_PERSON_ID REQUESTOR_ID, OEOH.HEADER_ID PO_HEADER_ID, NULL, TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), 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(OEOH.ORDER_NUMBER) PO_NUM_REL_NUM, OEOH.HEADER_ID ORDER_ID, OEOH.ORDER_NUMBER 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, TO_DATE(NULL) FROM MTL_UNITS_OF_MEASURE MUM, HR_ALL_ORGANIZATION_UNITS_TL OOD, PO_REQUISITION_HEADERS PORH, PO_REQUISITION_LINES PORL, PO_SYSTEM_PARAMETERS POSP, OE_ORDER_HEADERS_ALL OEOH, OE_ORDER_LINES_ALL OEOL, ORG_ORGANIZATION_DEFINITIONS OEORG WHERE PORL.QUANTITY - NVL(PORL.QUANTITY_CANCELLED, 0) - NVL(PORL.QUANTITY_DELIVERED, 0) > 0 AND PORL.SOURCE_TYPE_CODE = 'INVENTORY' 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) AND OEOH.ORDER_SOURCE_ID = NVL(POSP.ORDER_SOURCE_ID, 10) AND OEOH.HEADER_ID = OEOL.HEADER_ID AND OEOL.SOURCE_DOCUMENT_LINE_ID = PORL.REQUISITION_LINE_ID AND OEOH.ORIG_SYS_DOCUMENT_REF = PORH.SEGMENT1 AND OEOH.SOURCE_DOCUMENT_ID = PORL.REQUISITION_HEADER_ID AND NVL(OEOH.ORG_ID, -1) = NVL(OEORG.OPERATING_UNIT, -1) AND PORL.SOURCE_ORGANIZATION_ID = OEORG.ORGANIZATION_ID

View Text - HTML Formatted

SELECT SYSDATE RECEIPT_DATE
, PORL.TO_PERSON_ID REQUESTOR_ID
, OEOH.HEADER_ID PO_HEADER_ID
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, 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(OEOH.ORDER_NUMBER) PO_NUM_REL_NUM
, OEOH.HEADER_ID ORDER_ID
, OEOH.ORDER_NUMBER 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
, TO_DATE(NULL)
FROM MTL_UNITS_OF_MEASURE MUM
, HR_ALL_ORGANIZATION_UNITS_TL OOD
, PO_REQUISITION_HEADERS PORH
, PO_REQUISITION_LINES PORL
, PO_SYSTEM_PARAMETERS POSP
, OE_ORDER_HEADERS_ALL OEOH
, OE_ORDER_LINES_ALL OEOL
, ORG_ORGANIZATION_DEFINITIONS OEORG
WHERE PORL.QUANTITY - NVL(PORL.QUANTITY_CANCELLED
, 0) - NVL(PORL.QUANTITY_DELIVERED
, 0) > 0
AND PORL.SOURCE_TYPE_CODE = 'INVENTORY'
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)
AND OEOH.ORDER_SOURCE_ID = NVL(POSP.ORDER_SOURCE_ID
, 10)
AND OEOH.HEADER_ID = OEOL.HEADER_ID
AND OEOL.SOURCE_DOCUMENT_LINE_ID = PORL.REQUISITION_LINE_ID
AND OEOH.ORIG_SYS_DOCUMENT_REF = PORH.SEGMENT1
AND OEOH.SOURCE_DOCUMENT_ID = PORL.REQUISITION_HEADER_ID
AND NVL(OEOH.ORG_ID
, -1) = NVL(OEORG.OPERATING_UNIT
, -1)
AND PORL.SOURCE_ORGANIZATION_ID = OEORG.ORGANIZATION_ID