View: INL_SHIP_PO_OVERALL_V

Product:	INL - Oracle Landed Cost Management
Description:	This view shows overall information on Shipments for Purchase Orders
Implementation/DBA Data:	APPS.INL_SHIP_PO_OVERALL_V

View Text

SELECT CFOH.SHIP_HEADER_ID SHIP_HEADER_ID
, CFOH.ORGANIZATION_ID ORGANIZATION_ID
, CFOH.LOCATION_ID LOCATION_ID
, CFOH.ORG_ID ORG_ID
, CFOH.SHIP_TYPE_ID SHIP_TYPE_ID
, CFOT.SHIP_TYPE_CODE SHIP_TYPE_CODE
, CFOT.SHIP_TYPE_NAME SHIP_TYPE_NAME
, CFOH.SHIP_NUM SHIP_NUM
, CFOH.SHIP_DATE SHIP_DATE
, CFOH.SHIP_STATUS_CODE SHIP_STATUS_CODE
, CFOH.PENDING_MATCHING_FLAG PENDING_MATCHING_FLAG
, CFOH.PENDING_UPDATE_FLAG PENDING_UPDATE_FLAG
, CFOH.SIMULATION_ID SIMULATION_ID
, CFOLG.SHIP_LINE_GROUP_ID SHIP_LINE_GROUP_ID
, CFOLG.SHIP_LINE_GROUP_NUM SHIP_LINE_GROUP_NUM
, CFOLG.SHIP_LINE_GROUP_REFERENCE SHIP_LINE_GROUP_REFERENCE
, CFOLG.SRC_TYPE_CODE SRC_TYPE_CODE
, CFOLG.PARTY_ID GROUP_PARTY_ID
, HP.PARTY_NAME GROUP_PARTY_NAME
, CFOLG.PARTY_SITE_ID GROUP_PARTY_SITE_ID
, HPS.PARTY_SITE_NAME GROUP_PARTY_SITE_NAME
, NULL GROUP_ORGANIZATION_ID
, NULL GROUP_ORGANIZATION_NAME
, CFOL.SHIP_LINE_ID SHIP_LINE_ID
, CFOL.SHIP_LINE_NUM SHIP_LINE_NUM
, CFOL.PARENT_SHIP_LINE_ID EST_SHIP_LINE_ID
, SL.TXN_UNIT_PRICE EST_TXN_UNIT_PRICE
, CFOL.SHIP_LINE_SRC_TYPE_CODE SHIP_LINE_SRC_TYPE_CODE
, CFOL.SHIP_LINE_SOURCE_ID SHIP_LINE_SOURCE_ID
, CFOLT.SHIP_LINE_TYPE_CODE SHIP_LINE_TYPE_CODE
, CFOLT.SHIP_LINE_TYPE_NAME SHIP_LINE_TYPE_NAME
, CFOL.INVENTORY_ITEM_ID ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM
, PL.ITEM_REVISION ITEM_REVISION
, MSI.DESCRIPTION ITEM_DESCRIPTION
, CFOL.TXN_QTY TXN_QTY
, CFOL.TXN_UOM_CODE TXN_UOM_CODE
, CFOL.PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, CFOL.PRIMARY_QTY PRIMARY_QTY
, CFOL.SECONDARY_UOM_CODE SECONDARY_UOM_CODE
, CFOL.SECONDARY_QTY SECONDARY_QTY
, CFOL.TXN_UNIT_PRICE TXN_UNIT_PRICE
, CFOL.CURRENCY_CODE CURRENCY_CODE
, CFOL.CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CFOL.CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CFOL.CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, NVL(CFOL.TXN_QTY
, 0)*NVL(CFOL.TXN_UNIT_PRICE
, 0) LINE_AMT
, PH.PO_HEADER_ID SRC_ID
, FLV.DISPLAYED_FIELD SRC_TYPE
, PH.SEGMENT1 SRC_NUMBER
, NULL SRC_DESCRIPTION
, PH.ORG_ID SRC_ORG_ID
, PV.PARTY_ID SRC_PARTY_ID
, HP_SRC.PARTY_NAME SRC_PARTY_NAME
, PVS.PARTY_SITE_ID SRC_PARTY_SITE_ID
, HPS_SRC.PARTY_SITE_NAME SRC_PARTY_SITE_NAME
, PV.VENDOR_ID SRC_VENDOR_ID
, PV.VENDOR_NAME SRC_VENDOR_NAME
, PVS.VENDOR_SITE_ID SRC_VENDOR_SITE_ID
, PVS.VENDOR_SITE_CODE SRC_VENDOR_SITE_CODE
, NULL SRC_ORGANIZATION_ID
, NULL SRC_LOCATION_ID
, NULL SRC_CUSTOMER_ID
, NULL SRC_CUSTOMER_NAME
, NULL SRC_CUSTOMER_NUMBER
, NULL SRC_CUSTOMER_SITE_CODE
, NULL SRC_CUST_ITEM_NUM
, PR.RELEASE_NUM SRC_RELEASE_NUM
, PR.PO_RELEASE_ID SRC_RELEASE_ID
, PR.RELEASE_DATE SRC_RELEASE_DATE
, PL.PO_LINE_ID SRC_LINE_ID
, PL.LINE_NUM SRC_LINE_NUM
, PLL.LINE_LOCATION_ID SRC_SHIP_ID
, TO_CHAR(PLL.SHIPMENT_NUM) SRC_SHIP_NUM
, NULL SRC_SHIPPED_DATE
, PLL.QUANTITY SRC_QTY
, RSL.ITEM_ID SRC_ITEM_ID
, RSL.ITEM_REVISION SRC_ITEM_REVISION
, RSL.ITEM_DESCRIPTION SRC_ITEM_DESCRIPTION
, RSL.CONTAINER_NUM SRC_CONTAINER_NUM
, RSL.TRUCK_NUM SRC_TRUCK_NUM
, RSL.BAR_CODE_LABEL SRC_BAR_CODE_LABEL
, RSL.DELIVER_TO_PERSON_ID SRC_DELIVER_TO_PERSON_ID
, RSL.VENDOR_ITEM_NUM SRC_VENDOR_ITEM_NUM
, RSL.PACKING_SLIP SRC_PACKING_SLIP
, RSL.EMPLOYEE_ID SRC_EMPLOYEE_ID
, RSH.FREIGHT_CARRIER_CODE SRC_FREIGHT_CARRIER_CODE
, RSH.BILL_OF_LADING SRC_BILL_OF_LADING
, RT.ROUTING_HEADER_ID SRC_ROUTING_ID
, RT.INSPECTION_STATUS_CODE SRC_INSPECTION_STATUS_CODE
, RT.TRANSACTION_DATE SRC_TRANSACTION_DATE
FROM INL_SHIP_LINE_TYPES_VL CFOLT
, INL_SHIP_TYPES_VL CFOT
, MTL_SYSTEM_ITEMS_VL MSI
, (SELECT SL.SHIP_LINE_ID
, SL.TXN_UNIT_PRICE
, SL.INVENTORY_ITEM_ID
, SH.ORGANIZATION_ID
FROM INL_SHIP_LINES SL
, INL_SHIP_HEADERS SH
WHERE SH.SHIP_HEADER_ID = SL.SHIP_HEADER_ID ) SL
, PO_VENDORS PV
, PO_VENDOR_SITES PVS
, PO_LOOKUP_CODES FLV
, PO_HEADERS PH
, PO_RELEASES PR
, PO_LINES PL
, RCV_TRANSACTIONS RT
, RCV_SHIPMENT_HEADERS RSH
, RCV_SUPPLY RSUP
, RCV_SHIPMENT_LINES RSL
, PO_LINE_LOCATIONS PLL
, INL_ADJ_SHIP_LINES_V CFOL
, HZ_PARTIES HP
, HZ_PARTY_SITES HPS
, HZ_PARTIES HP_SRC
, HZ_PARTY_SITES HPS_SRC
, INL_SHIP_LINE_GROUPS CFOLG
, INL_SHIP_HEADERS CFOH
WHERE CFOLT.SHIP_LINE_TYPE_ID (+) = CFOL.SHIP_LINE_TYPE_ID
AND CFOT.SHIP_TYPE_ID (+) = CFOH.SHIP_TYPE_ID
AND MSI.INVENTORY_ITEM_ID (+) = SL.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID (+) = SL.ORGANIZATION_ID
AND SL.SHIP_LINE_ID (+) = NVL(CFOL.PARENT_SHIP_LINE_ID
, CFOL.SHIP_LINE_ID)
AND PVS.VENDOR_SITE_ID (+) = PH.VENDOR_SITE_ID
AND PV.VENDOR_ID (+) = PH.VENDOR_ID
AND FLV.LOOKUP_CODE (+) = PH.TYPE_LOOKUP_CODE
AND FLV.LOOKUP_TYPE (+) = 'PO TYPE'
AND PH.PO_HEADER_ID (+) = PL.PO_HEADER_ID
AND PR.PO_RELEASE_ID (+) = PLL.PO_RELEASE_ID
AND PL.PO_LINE_ID (+) = PLL.PO_LINE_ID
AND RT.TRANSACTION_ID (+) = RSUP.RCV_TRANSACTION_ID
AND RSH.SHIPMENT_HEADER_ID (+) = RSL.SHIPMENT_HEADER_ID
AND RSUP.SHIPMENT_LINE_ID (+) = RSL.SHIPMENT_LINE_ID
AND RSL.LCM_SHIPMENT_LINE_ID (+) = SL.SHIP_LINE_ID
AND PLL.LINE_LOCATION_ID (+) = CFOL.SHIP_LINE_SOURCE_ID
AND CFOL.SHIP_LINE_SRC_TYPE_CODE (+) = 'PO'
AND CFOL.SHIP_LINE_GROUP_ID (+) = CFOLG.SHIP_LINE_GROUP_ID
AND HP.PARTY_ID (+) = CFOLG.PARTY_ID
AND HPS.PARTY_SITE_ID (+) = CFOLG.PARTY_SITE_ID
AND HP_SRC.PARTY_ID (+) = PV.PARTY_ID
AND HPS_SRC.PARTY_SITE_ID (+) = PVS.PARTY_SITE_ID
AND CFOLG.SHIP_HEADER_ID (+) = CFOH.SHIP_HEADER_ID

Columns