View: MTL_PERIODS

Product:	INV - Inventory
Description:	View of period dates and inventory value for open periods
Implementation/DBA Data:	APPS.MTL_PERIODS

View Text

SELECT SUMMARY.ORGANIZATION_ID ORGANIZATION_ID
, OOD.ORGANIZATION_CODE ORGANIZATION_CODE
, OOD.ORGANIZATION_NAME ORGANIZATION_NAME
, PERIODS.PERIOD_NAME PERIOD_NAME
, PERIODS.PERIOD_YEAR PERIOD_YEAR
, PERIODS.PERIOD_START_DATE PERIOD_START_DATE
, PERIODS.SCHEDULE_CLOSE_DATE SCHEDULE_CLOSE_DATE
, SUMMARY.SECONDARY_INVENTORY SUB_INV
, SUMMARY.INVENTORY_VALUE VALUE
FROM MTL_PERIOD_SUMMARY SUMMARY
, ORG_ACCT_PERIODS PERIODS
, ORG_ORGANIZATION_DEFINITIONS OOD
WHERE SUMMARY.ORGANIZATION_ID = PERIODS.ORGANIZATION_ID
AND SUMMARY.ORGANIZATION_ID = OOD.ORGANIZATION_ID
AND SUMMARY.ACCT_PERIOD_ID = PERIODS.ACCT_PERIOD_ID
AND PERIODS.PERIOD_CLOSE_DATE IS NOT NULL
AND SUMMARY.INVENTORY_TYPE = 1

Columns