View: POR_RCV_INTERNAL_ITEMS_V

Product:	ICX - Oracle iProcurement
Description:
Implementation/DBA Data:	APPS.POR_RCV_INTERNAL_ITEMS_V

View Text

SELECT SYSDATE RECEIPT_DATE
, PORL.TO_PERSON_ID REQUESTOR_ID
, TO_NUMBER(NULL)
, 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
, PORL.USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, 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.ORDER_NUMBER
, PORL.REQUISITION_LINE_ID
, POR_RCV_TRANSACTION_SV.GET_SHIPMENT_NUM('REQ'
, PORL.REQUISITION_LINE_ID)
, 'REQ'
FROM MTL_UNITS_OF_MEASURE MUM
, HR_ALL_ORGANIZATION_UNITS_TL OOD
, PO_REQUISITION_HEADERS PORH
, PO_REQUISITION_LINES PORL
, OE_ORDER_HEADERS 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 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)

Columns