View: POR_RECEIPTS_SUMMARY_V

Product:	ICX - Oracle iProcurement
Description:	Receipts created for requisition lines
Implementation/DBA Data:	APPS.POR_RECEIPTS_SUMMARY_V

View Text

SELECT PRL.REQUISITION_LINE_ID
, PRL.LINE_LOCATION_ID
, RSH.RECEIPT_NUM
, TO_CHAR(RSH.CREATION_DATE
, FND_PROFILE.VALUE_WNPS('ICX_DATE_FORMAT_MASK'))
, RSH.FREIGHT_CARRIER_CODE
, RSL.PACKING_SLIP
, RSH.WAYBILL_AIRBILL_NUM
, RSL.QUANTITY_RECEIVED
, RSL.UNIT_OF_MEASURE
, RSL.COMMENTS
FROM PO_REQUISITION_LINES PRL
, RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
WHERE PRL.REQUISITION_LINE_ID = RSL.REQUISITION_LINE_ID
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID

Columns