VIEW: APPS.GL_SRS_GLRTB2_START_PERIOD

Source

View Text - Preformatted

SELECT 'A' ACTUAL_FLAG , -1 LEDGER_ID , MEANING PERIOD_NAME , -1 PERIOD_YEAR , -1 PERIOD_NUM FROM GL_LOOKUPS WHERE LOOKUP_TYPE = 'LITERAL' AND LOOKUP_CODE = 'N/A' UNION SELECT 'B' ACTUAL_FLAG, LEDGER_ID LEDGER_ID, PERIOD_NAME PERIOD_NAME, PERIOD_YEAR PERIOD_YEAR, PERIOD_NUM PERIOD_NUM FROM GL_PERIOD_STATUSES WHERE APPLICATION_ID = 101

View Text - HTML Formatted

SELECT 'A' ACTUAL_FLAG
, -1 LEDGER_ID
, MEANING PERIOD_NAME
, -1 PERIOD_YEAR
, -1 PERIOD_NUM
FROM GL_LOOKUPS
WHERE LOOKUP_TYPE = 'LITERAL'
AND LOOKUP_CODE = 'N/A' UNION SELECT 'B' ACTUAL_FLAG
, LEDGER_ID LEDGER_ID
, PERIOD_NAME PERIOD_NAME
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_NUM PERIOD_NUM
FROM GL_PERIOD_STATUSES
WHERE APPLICATION_ID = 101