[Home] [Help]
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
Name |
ORGANIZATION_ID |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
PERIOD_NAME |
PERIOD_YEAR |
PERIOD_START_DATE |
SCHEDULE_CLOSE_DATE |
SECONDARY_INVENTORY |
VALUE |