VIEW: APPS.RCV_FTE_HEADERS_V

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)