eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MTL_PERIODS

Source

View Text - Preformatted


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

View Text - HTML Formatted

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