View: RCV_FTE_HEADERS_V

Product:	PO - Purchasing
Description:	Header Lines for logistics
Implementation/DBA Data:	APPS.RCV_FTE_HEADERS_V

View Text

SELECT RSH.SHIPMENT_NUM
, RSH.RECEIPT_NUM
, RSH.SHIPMENT_HEADER_ID
, RSH.BILL_OF_LADING
, RSH.VENDOR_ID
, RSH.VENDOR_SITE_ID
, NVL(RSH.EXPECTED_RECEIPT_DATE
, RT.TRANSACTION_DATE)
, RSH.SHIPPED_DATE
, RSH.PACKING_SLIP
, FLV.LOOKUP_CODE FREIGHT_TERMS_CODE
, OFT.PARTY_ID CARRIER_ID
, RSH.WAYBILL_AIRBILL_NUM WAYBILL_AIRBILL_NUMBER
, RSH.SHIP_TO_ORG_ID ORGANIZATION_ID
, RSH.NUM_OF_CONTAINERS
, RSH.GROSS_WEIGHT
, RSH.GROSS_WEIGHT_UOM_CODE
, RSH.NET_WEIGHT
, RSH.NET_WEIGHT_UOM_CODE
, RSH.TAR_WEIGHT TARE_WEIGHT
, RSH.TAR_WEIGHT_UOM_CODE TARE_WEIGHT_UOM_CODE
, RSH.SHIP_TO_LOCATION_ID
, RSH.PACKAGING_CODE
, RSH.ASN_TYPE
, RT.EMPLOYEE_ID
, RSH.LAST_UPDATE_DATE
, RSH.LAST_UPDATED_BY
, RSH.CREATION_DATE
, RSH.CREATED_BY
, RSH.LAST_UPDATE_LOGIN
, RSH.SHIP_FROM_LOCATION_ID
FROM RCV_SHIPMENT_HEADERS RSH
, FND_LOOKUP_VALUES FLV
, ORG_FREIGHT_VL OFT
, (SELECT RT_1.SHIPMENT_HEADER_ID
, RT_1.TRANSACTION_DATE
, RT_1.EMPLOYEE_ID
FROM RCV_TRANSACTIONS RT_1
WHERE RT_1.TRANSACTION_ID = (SELECT MAX(RT_2.TRANSACTION_ID)
FROM RCV_TRANSACTIONS RT_2
WHERE RT_1.SHIPMENT_HEADER_ID = RT_2.SHIPMENT_HEADER_ID)) RT
WHERE RSH.FREIGHT_TERMS = FLV.MEANING(+)
AND 'FREIGHT TERMS' = FLV.LOOKUP_TYPE(+)
AND OFT.ORGANIZATION_ID(+) = RSH.SHIP_TO_ORG_ID
AND OFT.FREIGHT_CODE(+) = RSH.FREIGHT_CARRIER_CODE
AND RSH.SHIPMENT_HEADER_ID = RT.SHIPMENT_HEADER_ID(+)

Columns