View: MTL_BIS_INV_VALUE_V

Product:	INV - Inventory
Description:	Stores Onhand/Intransit quantity and value for Inventory items at organization and intransit owning organizations respectively.
Implementation/DBA Data:	APPS.MTL_BIS_INV_VALUE_V

View Text

SELECT MOH.ORGANIZATION_ID
, MOH.INVENTORY_ITEM_ID
, MOH.SUBINVENTORY_CODE
, MOH.TRANSACTION_QUANTITY QUANTITY
, MOH.TRANSACTION_QUANTITY * MOH.ITEM_COST VALUE
FROM MTL_ONHAND_QTY_COST_V MOH UNION ALL SELECT CIVV.INTRANSIT_OWNING_ORG_ID
, CIVV.INVENTORY_ITEM_ID
, 'INTRANSIT'
, DECODE(CIVV.INTRANSIT_OWNING_ORG_ID
, CIVV.FROM_ORGANIZATION_ID
, CIVV.QUANTITY
, CIVV.TO_ORGANIZATION_ID
, CIVV.TO_ORG_PRIMARY_QUANTITY) QUANTITY
, DECODE(CIVV.INTRANSIT_OWNING_ORG_ID
, CIVV.FROM_ORGANIZATION_ID
, CIVV.QUANTITY * CST.ITEM_COST
, CIVV.TO_ORGANIZATION_ID
, CIVV.TO_ORG_PRIMARY_QUANTITY * CST.ITEM_COST) VALUE
FROM CST_INTRANSIT_VALUE_VIEW CIVV
, CST_CG_ITEM_COSTS_VIEW CST
, MTL_PARAMETERS MP1
WHERE CST.ORGANIZATION_ID = MP1.COST_ORGANIZATION_ID
AND CST.INVENTORY_ITEM_ID = CIVV.INVENTORY_ITEM_ID
AND CST.COST_GROUP_ID = 1
AND CIVV.FROM_ORGANIZATION_ID = MP1.ORGANIZATION_ID
AND CIVV.FROM_ORGANIZATION_ID = CIVV.INTRANSIT_OWNING_ORG_ID UNION ALL SELECT CIVV.INTRANSIT_OWNING_ORG_ID
, CIVV.INVENTORY_ITEM_ID
, 'INTRANSIT'
, DECODE(CIVV.INTRANSIT_OWNING_ORG_ID
, CIVV.FROM_ORGANIZATION_ID
, CIVV.QUANTITY
, CIVV.TO_ORGANIZATION_ID
, CIVV.TO_ORG_PRIMARY_QUANTITY) QUANTITY
, DECODE(CIVV.INTRANSIT_OWNING_ORG_ID
, CIVV.FROM_ORGANIZATION_ID
, CIVV.QUANTITY * CST.ITEM_COST
, CIVV.TO_ORGANIZATION_ID
, CIVV.TO_ORG_PRIMARY_QUANTITY * CST.ITEM_COST) VALUE
FROM CST_INTRANSIT_VALUE_VIEW CIVV
, CST_CG_ITEM_COSTS_VIEW CST
, MTL_PARAMETERS MP2
WHERE CST.ORGANIZATION_ID = MP2.COST_ORGANIZATION_ID
AND CST.INVENTORY_ITEM_ID = CIVV.INVENTORY_ITEM_ID
AND CST.COST_GROUP_ID = 1
AND CIVV.TO_ORGANIZATION_ID = MP2.ORGANIZATION_ID
AND CIVV.TO_ORGANIZATION_ID = CIVV.INTRANSIT_OWNING_ORG_ID

Columns