FND Design Data [Home] [Help]

View: INVBV_INV_BY_PERIOD_AND_ITEM

Product: INV - Inventory
Description: retrofitted
Implementation/DBA Data: ViewAPPS.INVBV_INV_BY_PERIOD_AND_ITEM
View Text

SELECT MBI.ORGANIZATION_ID
, MBI.ACCT_PERIOD_ID
, MBI.ONHAND
, MBI.WIP
, MBI.INTRANSIT
, MBI.COGS
, MBI.INVENTORY_ITEM_ID
, MBI.CREATED_BY
, MBI.CREATION_DATE
, MBI.LAST_UPDATED_BY
, MBI.LAST_UPDATE_DATE
FROM MTL_BIS_INV_BY_PERIOD MBI
WHERE '_SEC:MBI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns

Name
ORGANIZATION_ID
ACCT_PERIOD_ID
ONHAND
WIP
INTRANSIT
COST_OF_GOOD_SOLD
INVENTORY_ITEM_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE