View: CST_INTRANSIT_VALUE_VIEW

Product:	BOM - Bills of Material
Description:	Intransit value information : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_INTRANSIT_VALUE_VIEW

View Text

SELECT DECODE(MIP.FOB_POINT
, 1
, SUP.TO_ORGANIZATION_ID
, 2
, SUP.FROM_ORGANIZATION_ID)
, NVL(SUP.COST_GROUP_ID
, DECODE(MP.PRIMARY_COST_METHOD
, 1
, NULL
, 2
, MP.DEFAULT_COST_GROUP_ID
, 5
, MP.DEFAULT_COST_GROUP_ID
, 6
, MP.DEFAULT_COST_GROUP_ID))
, SUP.FROM_ORGANIZATION_ID
, SUP.FROM_SUBINVENTORY
, SUP.TO_ORGANIZATION_ID
, SUP.TO_SUBINVENTORY
, SUP.SUPPLY_TYPE_CODE
, MIP.FOB_POINT
, RSH.SHIPMENT_NUM
, RSH.RECEIPT_NUM
, RSH.FREIGHT_CARRIER_CODE
, RSH.WAYBILL_AIRBILL_NUM
, RSH.NUM_OF_CONTAINERS
, SUP.ITEM_ID
, SUP.ITEM_REVISION
, SUP.QUANTITY
, SUP.UNIT_OF_MEASURE
, UOM1.UOM_CODE
, SUP.TO_ORG_PRIMARY_QUANTITY
, SUP.TO_ORG_PRIMARY_UOM
, UOM2.UOM_CODE
, SUP.RECEIPT_DATE
, SUP.NEED_BY_DATE
, SUP.EXPECTED_DELIVERY_DATE
, RSH.SHIPPED_DATE
, SUP.DESTINATION_TYPE_CODE
, RSL.SHIPMENT_LINE_STATUS_CODE
, RSL.SOURCE_DOCUMENT_CODE
, RSL.DELIVER_TO_LOCATION_ID
, RSL.CHARGE_ACCOUNT_ID
, RSL.TRANSPORTATION_ACCOUNT_ID
, RSL.SHIPMENT_UNIT_PRICE
, RSL.TRANSFER_COST
, RSL.TRANSPORTATION_COST
, RSL.SHIPMENT_LINE_ID
FROM RCV_SHIPMENT_HEADERS RSH
, RCV_SHIPMENT_LINES RSL
, MTL_INTERORG_PARAMETERS MIP
, MTL_UNITS_OF_MEASURE UOM1
, MTL_UNITS_OF_MEASURE UOM2
, MTL_SUPPLY SUP
, MTL_PARAMETERS MP
WHERE SUP.SUPPLY_TYPE_CODE IN ('SHIPMENT'
, 'RECEIVING')
AND MIP.FROM_ORGANIZATION_ID = SUP.FROM_ORGANIZATION_ID
AND MIP.TO_ORGANIZATION_ID = SUP.TO_ORGANIZATION_ID
AND RSH.SHIPMENT_HEADER_ID = SUP.SHIPMENT_HEADER_ID
AND RSL.SHIPMENT_LINE_ID = SUP.SHIPMENT_LINE_ID
AND UOM1.UNIT_OF_MEASURE = SUP.UNIT_OF_MEASURE
AND UOM2.UNIT_OF_MEASURE = SUP.TO_ORG_PRIMARY_UOM
AND MP.ORGANIZATION_ID = DECODE(MIP.FOB_POINT
, 1
, SUP.TO_ORGANIZATION_ID
, 2
, SUP.FROM_ORGANIZATION_ID)

Columns