View: POS_VIEW_ASN

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.POS_VIEW_ASN

View Text

SELECT DISTINCT RHI.SHIPMENT_NUM
, RHI.SHIPPED_DATE
, RHI.EXPECTED_RECEIPT_DATE
, RHI.FREIGHT_CARRIER_CODE
, RHI.INVOICE_NUM
, API.INVOICE_ID
, RHI.WAYBILL_AIRBILL_NUM
, RHI.NUM_OF_CONTAINERS
, RHI.FREIGHT_TERMS
, RHI.BILL_OF_LADING
, RHI.PACKING_SLIP
, RHI.PACKAGING_CODE
, RHI.VENDOR_NAME
, RHI.VENDOR_SITE_CODE
, RHI.CARRIER_EQUIPMENT
, RHI.CARRIER_METHOD
, RHI.RECEIPT_NUM
, RHI.LOCATION_CODE
, RHI.HAZARD_CODE
, RHI.HAZARD_CLASS
, RHI.HAZARD_DESCRIPTION
, RHI.SHIP_TO_ORGANIZATION_CODE
, RHI.SPECIAL_HANDLING_CODE
, RHI.TAR_WEIGHT
, RHI.TAR_WEIGHT_UOM_CODE
, RHI.NET_WEIGHT
, RHI.NET_WEIGHT_UOM_CODE
, RHI.USGGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, RHI.COMMENTS
, RHI.PROCESSING_STATUS_CODE
, RTI.VENDOR_ID
, RTI.VENDOR_SITE_ID
FROM RCV_HEADERS_INTERFACE RHI
, RCV_TRANSACTIONS_INTERFACE RTI
, AP_INVOICES_ALL API
WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID
AND API.INVOICE_NUM(+) = RHI.INVOICE_NUM
AND ASN_TYPE IN ('ASN'
, 'ASBN') UNION SELECT DISTINCT RSH.SHIPMENT_NUM
, RSH.SHIPPED_DATE
, RSH.EXPECTED_RECEIPT_DATE
, RSH.FREIGHT_CARRIER_CODE
, RSH.INVOICE_NUM
, API.INVOICE_ID
, RSH.WAYBILL_AIRBILL_NUM
, RSH.NUM_OF_CONTAINERS
, RSH.FREIGHT_TERMS
, RSH.BILL_OF_LADING
, RSH.PACKING_SLIP
, RSH.PACKAGING_CODE
, POV.VENDOR_NAME
, PVS.VENDOR_SITE_CODE
, RSH.CARRIER_EQUIPMENT
, RSH.CARRIER_METHOD
, RSH.RECEIPT_NUM
, HRL.LOCATION_CODE
, RSH.HAZARD_CODE
, RSH.HAZARD_CLASS
, RSH.HAZARD_DESCRIPTION
, OOD.ORGANIZATION_CODE
, RSH.SPECIAL_HANDLING_CODE
, RSH.TAR_WEIGHT
, RSH.TAR_WEIGHT_UOM_CODE
, RSH.NET_WEIGHT
, RSH.NET_WEIGHT_UOM_CODE
, RSH.USSGL_TRANSACTION_CODE
, RSH.COMMENTS
, '' PROCESSING_STATUS_CODE
, RSH.VENDOR_ID
, RSH.VENDOR_SITE_ID
FROM RCV_SHIPMENT_HEADERS RSH
, AP_INVOICES_ALL API
, PO_VENDORS POV
, PO_VENDOR_SITES PVS
, HR_LOCATIONS_ALL HRL
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE ASN_TYPE IN ('ASN'
, 'ASBN')
AND API.INVOICE_NUM(+) = RSH.INVOICE_NUM
AND POV.VENDOR_ID(+) = RSH.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = RSH.VENDOR_SITE_ID
AND HRL.LOCATION_ID (+) = RSH.SHIP_TO_LOCATION_ID
AND OOD.ORGANIZATION_ID (+) = RSH.ORGANIZATION_ID ORDER BY SHIPPED_DATE DESC

Columns