VIEW: APPS.ORG_ACCT_PERIODS_V

Source

View Text - Preformatted

SELECT Z.ROWID , 'ORG_PERIOD' , Z.ORGANIZATION_ID , Z.ACCT_PERIOD_ID , NULL , NULL , X.MEANING , Z.PERIOD_NAME , Z.PERIOD_NUM , Z.PERIOD_YEAR , Z.PERIOD_START_DATE , Z.SCHEDULE_CLOSE_DATE , Z.PERIOD_CLOSE_DATE , Z.LAST_UPDATE_DATE , Z.LAST_UPDATED_BY , Z.CREATION_DATE , Z.CREATED_BY , Z.LAST_UPDATE_LOGIN FROM ORG_ACCT_PERIODS Z, MFG_LOOKUPS X WHERE X.LOOKUP_TYPE(+) = 'MTL_ACCT_PERIOD_STATUS' AND X.ENABLED_FLAG(+) = 'Y' AND X.LOOKUP_CODE(+) = DECODE(NVL(Z.PERIOD_CLOSE_DATE,SYSDATE), Z.PERIOD_CLOSE_DATE, DECODE(Z.OPEN_FLAG, 'N', DECODE(SUMMARIZED_FLAG,'N',65,66), 'Y', 4, 'P', 2, 4), 3 ) UNION ALL SELECT Y.ROWID, 'GL_PERIOD', 0, 0, Y.PERIOD_TYPE, Y.PERIOD_SET_NAME, X.MEANING, Y.PERIOD_NAME, Y.PERIOD_NUM, Y.PERIOD_YEAR, Y.START_DATE, Y.END_DATE, TO_DATE(NULL), Y.LAST_UPDATE_DATE, Y.LAST_UPDATED_BY, Y.CREATION_DATE, Y.CREATED_BY, Y.LAST_UPDATE_LOGIN FROM GL_PERIODS Y, MFG_LOOKUPS X WHERE ( Y.ADJUSTMENT_PERIOD_FLAG = 'N' ) AND X.LOOKUP_TYPE(+) = 'MTL_ACCT_PERIOD_STATUS' AND X.ENABLED_FLAG(+) = 'Y' AND X.LOOKUP_CODE (+)= 67

View Text - HTML Formatted

SELECT Z.ROWID
, 'ORG_PERIOD'
, Z.ORGANIZATION_ID
, Z.ACCT_PERIOD_ID
, NULL
, NULL
, X.MEANING
, Z.PERIOD_NAME
, Z.PERIOD_NUM
, Z.PERIOD_YEAR
, Z.PERIOD_START_DATE
, Z.SCHEDULE_CLOSE_DATE
, Z.PERIOD_CLOSE_DATE
, Z.LAST_UPDATE_DATE
, Z.LAST_UPDATED_BY
, Z.CREATION_DATE
, Z.CREATED_BY
, Z.LAST_UPDATE_LOGIN
FROM ORG_ACCT_PERIODS Z
, MFG_LOOKUPS X
WHERE X.LOOKUP_TYPE(+) = 'MTL_ACCT_PERIOD_STATUS'
AND X.ENABLED_FLAG(+) = 'Y'
AND X.LOOKUP_CODE(+) = DECODE(NVL(Z.PERIOD_CLOSE_DATE
, SYSDATE)
, Z.PERIOD_CLOSE_DATE
, DECODE(Z.OPEN_FLAG
, 'N'
, DECODE(SUMMARIZED_FLAG
, 'N'
, 65
, 66)
, 'Y'
, 4
, 'P'
, 2
, 4)
, 3 ) UNION ALL SELECT Y.ROWID
, 'GL_PERIOD'
, 0
, 0
, Y.PERIOD_TYPE
, Y.PERIOD_SET_NAME
, X.MEANING
, Y.PERIOD_NAME
, Y.PERIOD_NUM
, Y.PERIOD_YEAR
, Y.START_DATE
, Y.END_DATE
, TO_DATE(NULL)
, Y.LAST_UPDATE_DATE
, Y.LAST_UPDATED_BY
, Y.CREATION_DATE
, Y.CREATED_BY
, Y.LAST_UPDATE_LOGIN
FROM GL_PERIODS Y
, MFG_LOOKUPS X
WHERE ( Y.ADJUSTMENT_PERIOD_FLAG = 'N' )
AND X.LOOKUP_TYPE(+) = 'MTL_ACCT_PERIOD_STATUS'
AND X.ENABLED_FLAG(+) = 'Y'
AND X.LOOKUP_CODE (+)= 67