View: INV_BIS_SUPPLY_CHAIN_INVENTORY

Product:	INV - Inventory
Description:	Supply Chain Inventory Information
Implementation/DBA Data:	APPS.INV_BIS_SUPPLY_CHAIN_INVENTORY

View Text

SELECT MOH.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS INVENTORY_ITEM_NAME
, MOH.ORGANIZATION_ID ORGANIZATION_ID
, HAO.NAME ORGANIZATION_NAME
, MOH.SUBINVENTORY_CODE SUBINVENTORY_NAME
, MOH.TRANSACTION_QUANTITY ONHAND_QUANTITY
, 0 INTRANSIT_QUANTITY
, MOH.ITEM_COST ITEM_COST
FROM MTL_SYSTEM_ITEMS_B_KFV MSI
, MTL_ONHAND_QTY_COST_V MOH
, HR_ALL_ORGANIZATION_UNITS HAO
WHERE MSI.ORGANIZATION_ID = MOH.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MOH.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = HAO.ORGANIZATION_ID UNION ALL SELECT CIVV.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSIBK.CONCATENATED_SEGMENTS INVENTORY_ITEM_NAME
, CIVV.INTRANSIT_OWNING_ORG_ID ORGANIZATION_ID
, HAO.NAME ORGANIZATION_NAME
, DECODE(CIVV.INTRANSIT_OWNING_ORG_ID
, CIVV.FROM_ORGANIZATION_ID
, CIVV.FROM_SUBINVENTORY
, CIVV.TO_SUBINVENTORY) SUBINVENTORY_NAME
, 0 ONHAND_QUANTITY
, CIVV.QUANTITY INTRANSIT_QUANTITY
, CCICV.ITEM_COST ITEM_COST
FROM MTL_SYSTEM_ITEMS_B_KFV MSIBK
, CST_INTRANSIT_VALUE_VIEW CIVV
, HR_ALL_ORGANIZATION_UNITS HAO
, (SELECT MP.DEFAULT_COST_GROUP_ID DEFAULT_COST_GROUP_ID
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, NVL(MP.DEFAULT_COST_GROUP_ID
, 1)
, CQL.COST_GROUP_ID) COST_GROUP_ID
, NVL( DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.ITEM_COST
, CQL.ITEM_COST)
, 0) ITEM_COST
, CIC.INVENTORY_ITEM_ID
, MP.ORGANIZATION_ID
FROM CST_QUANTITY_LAYERS CQL
, MTL_PARAMETERS MP
, CST_ITEM_COSTS CIC
WHERE CQL.INVENTORY_ITEM_ID(+) = CIC.INVENTORY_ITEM_ID AND CQL.ORGANIZATION_ID(+) = CIC.ORGANIZATION_ID AND MP.COST_ORGANIZATION_ID = CIC.ORGANIZATION_ID AND MP.PRIMARY_COST_METHOD = CIC.COST_TYPE_ID) CCICV
WHERE CIVV.INTRANSIT_OWNING_ORG_ID = HAO.ORGANIZATION_ID
AND CIVV.INVENTORY_ITEM_ID = MSIBK.INVENTORY_ITEM_ID
AND CIVV.INTRANSIT_OWNING_ORG_ID = MSIBK.ORGANIZATION_ID
AND CIVV.INTRANSIT_OWNING_ORG_ID = CCICV.ORGANIZATION_ID
AND CIVV.INVENTORY_ITEM_ID = CCICV.INVENTORY_ITEM_ID
AND NVL(CIVV.COST_GROUP_ID
, CCICV.DEFAULT_COST_GROUP_ID) = CCICV.COST_GROUP_ID

Columns