SELECT DISTINCT
RHI.SHIPMENT_NUM,
RHI.SHIPPED_DATE,
RHI.EXPECTED_RECEIPT_DATE,
RHI.FREIGHT_CARRIER_CODE,
RHI.INVOICE_NUM,
RHI.WAYBILL_AIRBILL_NUM,
RHI.NUM_OF_CONTAINERS,
RHI.FREIGHT_TERMS,
RHI.BILL_OF_LADING,
RHI.PACKING_SLIP,
RHI.PACKAGING_CODE,
POV.VENDOR_NAME,
POV.SEGMENT1 VENDOR_NUMBER,
PVS.VENDOR_SITE_CODE,
RHI.SPECIAL_HANDLING_CODE,
RHI.TAR_WEIGHT,
RHI.TAR_WEIGHT_UOM_CODE,
RHI.NET_WEIGHT,
RHI.NET_WEIGHT_UOM_CODE,
RHI.COMMENTS,
” CANCELLATION_STATUS,
” PROCESSING_STATUS,
RHI.VENDOR_ID,
RHI.VENDOR_SITE_ID,
NULL PAYMENT_STATUS_FLAG,
RHI.CREATION_DATE,
RHI.HEADER_INTERFACE_ID HEADER_ID,
RHI.SHIP_FROM_LOCATION_ID,
SUBSTR (PS.party_site_number,
1,
INSTR (PS.party_site_number, ‘|’))
location_code,
RHI.CREATED_BY
FROM RCV_HEADERS_INTERFACE RHI,
RCV_TRANSACTIONS_INTERFACE RTI,
PO_VENDORS POV,
PO_VENDOR_SITES_ALL PVS,
HZ_PARTY_SITES PS
WHERE RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID
AND POV.VENDOR_ID = RHI.VENDOR_ID
AND PVS.VENDOR_SITE_ID(+) = RHI.VENDOR_SITE_ID
AND RHI.ASN_TYPE IN (‘ASN’, ‘ASBN’)
AND RHI.SHIP_FROM_LOCATION_ID = PS.LOCATION_ID(+)
AND RHI.PROCESSING_STATUS_CODE=’DRAFT_ASN’
Recent Posts