View: POR_RCV_CONF_ITEMS_V

Product:	ICX - Oracle iProcurement
Description:	View for querying items displayed on the confirmation page of the receive items flow.
Implementation/DBA Data:	APPS.POR_RCV_CONF_ITEMS_V

View Text

SELECT RSH.RECEIPT_NUM
, RT.TRANSACTION_DATE
, PORH.SEGMENT1
, PORL.ITEM_DESCRIPTION
, MUOM.UNIT_OF_MEASURE_TL
, RSL.QUANTITY_RECEIVED
, RSH.WAYBILL_AIRBILL_NUM
, RSL.PACKING_SLIP
, RSL.USSGL_TRANSACTION_CODE
, RSL.COMMENTS
, RSH.COMMENTS
, HOU.NAME SOURCE
, HOU1.NAME DESTINATION_ORGANIZATION
, RT.GROUP_ID
FROM PO_REQUISITION_LINES PORL
, PO_REQUISITION_HEADERS PORH
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, RCV_TRANSACTIONS RT
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_ALL_ORGANIZATION_UNITS HOU1
, MTL_UNITS_OF_MEASURE MUOM
WHERE RT.TRANSACTION_TYPE = 'DELIVER'
AND RT.SOURCE_DOCUMENT_CODE = 'REQ'
AND RT.UNIT_OF_MEASURE = MUOM.UNIT_OF_MEASURE
AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND PORL.REQUISITION_LINE_ID = RSL.REQUISITION_LINE_ID
AND PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID
AND HOU.ORGANIZATION_ID = PORL.SOURCE_ORGANIZATION_ID
AND HOU1.ORGANIZATION_ID = RSL.TO_ORGANIZATION_ID UNION ALL SELECT RSH.RECEIPT_NUM
, RT.TRANSACTION_DATE
, DECODE(RSL.PO_DISTRIBUTION_ID
, NULL
, NULL
, (SELECT PORH.SEGMENT1
FROM PO_REQUISITION_LINES PORL
, PO_REQUISITION_HEADERS PORH
, PO_DISTRIBUTIONS POD
, PO_REQ_DISTRIBUTIONS PORD
WHERE PORD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID
AND PORL.REQUISITION_LINE_ID = PORD.REQUISITION_LINE_ID
AND PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID
AND POD.PO_DISTRIBUTION_ID = RSL.PO_DISTRIBUTION_ID))
, SUBSTR( POL.ITEM_DESCRIPTION
, 1
, 240) ITEM_DESCRIPTION
, MUOM.UNIT_OF_MEASURE_TL
, RSL.QUANTITY_RECEIVED
, RSH.WAYBILL_AIRBILL_NUM
, RSL.PACKING_SLIP
, RSL.USSGL_TRANSACTION_CODE
, RSL.COMMENTS
, RSH.COMMENTS
, POV.VENDOR_NAME VENDOR
, HOU.NAME DESTINATION_ORGANIZATION
, RT.GROUP_ID
FROM PO_LINES POL
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, RCV_TRANSACTIONS RT
, PO_VENDORS POV
, MTL_UNITS_OF_MEASURE MUOM
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE RT.TRANSACTION_TYPE = 'DELIVER'
AND RT.SOURCE_DOCUMENT_CODE = 'PO'
AND RT.UNIT_OF_MEASURE = MUOM.UNIT_OF_MEASURE
AND RSL.SHIPMENT_LINE_ID = RT.SHIPMENT_LINE_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND POV.VENDOR_ID = RSH.VENDOR_ID
AND HOU.ORGANIZATION_ID = RSL.TO_ORGANIZATION_ID
AND POL.PO_LINE_ID = RSL.PO_LINE_ID

Columns