[Home] [Help]
View: 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
Name |
ROW_ID |
ORGANIZATION_ID |
ACCT_PERIOD_ID |
SECONDARY_INVENTORY |
DESCRIPTION |
INVENTORY_VALUE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |