View: JAI_BOE_ASBN_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_BOE_ASBN_V

View Text

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

Columns