View: MTL_PERIOD_SUMMARY_V

Product:	INV - Inventory
Description:	10SC ONLY
Implementation/DBA Data:	APPS.MTL_PERIOD_SUMMARY_V

View Text

SELECT A.ROWID
, A.ORGANIZATION_ID
, A.ACCT_PERIOD_ID
, A.SECONDARY_INVENTORY
, B.DESCRIPTION
, A.INVENTORY_VALUE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATE_LOGIN
FROM MTL_PERIOD_SUMMARY A
, MTL_SECONDARY_INVENTORIES B
WHERE A.ORGANIZATION_ID = B.ORGANIZATION_ID
AND A.INVENTORY_TYPE = 1
AND A.SECONDARY_INVENTORY = B.SECONDARY_INVENTORY_NAME
AND (B.SUBINVENTORY_TYPE = 1 OR B.SUBINVENTORY_TYPE IS NULL)

Columns