View: INVFV_INV_BY_PERIOD_AND_ITEM

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.INVFV_INV_BY_PERIOD_AND_ITEM

View Text

SELECT MBI.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MBI.ACCT_PERIOD_ID
, OAP.PERIOD_NAME
, OAP.PERIOD_SET_NAME
, OAP.PERIOD_YEAR
, OAP.PERIOD_NUM
, MBI.ONHAND
, MBI.WIP
, MBI.INTRANSIT
, MBI.BOP_ONHAND
, MBI.BOP_WIP
, MBI.BOP_INTRANSIT
, MBI.COGS
, MBI.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI'
, MBI.CREATED_BY
, MBI.CREATION_DATE
, MBI.LAST_UPDATED_BY
, MBI.LAST_UPDATE_DATE
FROM MTL_BIS_INV_BY_PERIOD MBI
, MTL_SYSTEM_ITEMS MSI
, ORG_ACCT_PERIODS OAP
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
WHERE MSI.INVENTORY_ITEM_ID = MBI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MBI.ORGANIZATION_ID
AND OAP.ACCT_PERIOD_ID = MBI.ACCT_PERIOD_ID
AND MP.ORGANIZATION_ID = MBI.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MBI.ORGANIZATION_ID
AND '_SEC:MBI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns