VIEW: APPS.JAI_BOE_ASBN_V

Source

View Text - Preformatted

SELECT asbn.asbn_number, asbn.asbn_id, asbn.po_line_id, asbn.line_location_id, asbn.shipment_num, asbn.item_id, asbn.unit_of_measure, asbn.quantity, asbn.vendor_id, asbn.vendor_site_id, asbn.org_id, asbn.currency_code, asbn.ship_to_organization_Id FROM (SELECT rhi.shipment_num asbn_number, rti.header_interface_id asbn_id, rti.po_line_id, pll.line_location_id, pll.shipment_num, rti.item_id, rti.unit_of_measure, pll.quantity, ph.vendor_id, ph.vendor_site_id, ph.org_id, ph.currency_code, pll.ship_to_organization_Id FROM rcv_headers_interface rhi, rcv_transactions_interface rti, po_headers_all ph, po_line_locations_all pll WHERE rhi.header_interface_id = rti.header_interface_id AND rti.po_header_id = ph.po_header_id AND rti.po_line_location_id = pll.line_location_id AND rhi.asn_type IN ('ASN', 'ASBN') AND rhi.transaction_type <> 'CANCEL' UNION SELECT rsh.shipment_num asbn_number, rsh.shipment_header_id asbn_id, rsl.po_line_id, pll.line_location_id, pll.shipment_num, rsl.item_id, rsl.unit_of_measure, pll.quantity, poh.vendor_id, poh.vendor_site_id, poh.org_id, poh.currency_code, pll.ship_to_organization_Id FROM rcv_shipment_headers rsh, rcv_shipment_lines rsl, po_headers_all poh, po_line_locations_all pll WHERE rsh.receipt_source_code = 'VENDOR' AND rsh.shipment_header_id = rsl.shipment_header_id AND rsl.po_line_location_id = pll.line_location_id AND rsh.asn_type IN ('ASN', 'ASBN') AND poh.po_header_id(+) = rsl.po_header_id) asbn order by asbn.asbn_number

View Text - HTML Formatted

SELECT ASBN.ASBN_NUMBER
, ASBN.ASBN_ID
, ASBN.PO_LINE_ID
, ASBN.LINE_LOCATION_ID
, ASBN.SHIPMENT_NUM
, ASBN.ITEM_ID
, ASBN.UNIT_OF_MEASURE
, ASBN.QUANTITY
, ASBN.VENDOR_ID
, ASBN.VENDOR_SITE_ID
, ASBN.ORG_ID
, ASBN.CURRENCY_CODE
, ASBN.SHIP_TO_ORGANIZATION_ID
FROM (SELECT RHI.SHIPMENT_NUM ASBN_NUMBER
, RTI.HEADER_INTERFACE_ID ASBN_ID
, RTI.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, PLL.SHIPMENT_NUM
, RTI.ITEM_ID
, RTI.UNIT_OF_MEASURE
, PLL.QUANTITY
, PH.VENDOR_ID
, PH.VENDOR_SITE_ID
, PH.ORG_ID
, PH.CURRENCY_CODE
, PLL.SHIP_TO_ORGANIZATION_ID
FROM RCV_HEADERS_INTERFACE RHI
, RCV_TRANSACTIONS_INTERFACE RTI
, PO_HEADERS_ALL PH
, PO_LINE_LOCATIONS_ALL PLL
WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID
AND RTI.PO_HEADER_ID = PH.PO_HEADER_ID
AND RTI.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
AND RHI.ASN_TYPE IN ('ASN'
, 'ASBN')
AND RHI.TRANSACTION_TYPE <> 'CANCEL' UNION SELECT RSH.SHIPMENT_NUM ASBN_NUMBER
, RSH.SHIPMENT_HEADER_ID ASBN_ID
, RSL.PO_LINE_ID
, PLL.LINE_LOCATION_ID
, PLL.SHIPMENT_NUM
, RSL.ITEM_ID
, RSL.UNIT_OF_MEASURE
, PLL.QUANTITY
, POH.VENDOR_ID
, POH.VENDOR_SITE_ID
, POH.ORG_ID
, POH.CURRENCY_CODE
, PLL.SHIP_TO_ORGANIZATION_ID
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, PO_HEADERS_ALL POH
, PO_LINE_LOCATIONS_ALL PLL
WHERE RSH.RECEIPT_SOURCE_CODE = 'VENDOR'
AND RSH.SHIPMENT_HEADER_ID = RSL.SHIPMENT_HEADER_ID
AND RSL.PO_LINE_LOCATION_ID = PLL.LINE_LOCATION_ID
AND RSH.ASN_TYPE IN ('ASN'
, 'ASBN')
AND POH.PO_HEADER_ID(+) = RSL.PO_HEADER_ID) ASBN ORDER BY ASBN.ASBN_NUMBER