Product: | FV - Federal Financials |
---|---|
Description: | The View is used to retrieve receipt details in the form 'Document Cross-Reference' |
Implementation/DBA Data: | APPS.FV_RECEIPT_MASTER_V |
SELECT DISTINCT PH.ORG_ID
, RSH.SHIPMENT_HEADER_ID
, RSL.SHIPMENT_LINE_ID
, PLL.LINE_LOCATION_ID
, RSH.VENDOR_ID
, PH.VENDOR_SITE_ID
, RSH.RECEIPT_NUM
, RSH.CREATION_DATE RECEIPT_DATE
, RSL.QUANTITY_RECEIVED
, RSL.UNIT_OF_MEASURE
, RSL.ITEM_DESCRIPTION
, RSL.SHIPMENT_LINE_STATUS_CODE
, DECODE(NVL(RSL.PACKING_SLIP
, '1')
, '1'
, RSH.PACKING_SLIP
, RSL.PACKING_SLIP) PACKING_SLIP
, RSH.SHIPMENT_NUM
, RSH.SHIPPED_DATE SHIP_DATE
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_LINE_LOCATIONS_ALL PLL
, RCV_TRANSACTIONS RT
, PO_HEADERS PH
WHERE RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND RSL.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
AND PLL.PO_HEADER_ID = PH.PO_HEADER_ID
AND RT.SHIPMENT_LINE_ID = RSL.SHIPMENT_LINE_ID