VIEW: APPS.FV_RECEIPT_MASTER_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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