VIEW: APPS.INVFV_INV_BY_PERIOD_AND_ITEM

Source

View Text - Preformatted

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

View Text - HTML Formatted

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