VIEW: APPS.GL_CONS_SET_NAMES_V

Source

View Text - Preformatted

SELECT CONS.consolidation_set_id CONSOLIDATION_SET_ID, CONS.name CONS_SET_NAME, CONS.description DESCRIPTION, CONS.to_ledger_id TO_LEDGER_ID, NVL(CONS.run_journal_import_flag, 'Y') JOURNAL_IMPORT_FLAG, NVL(CONS.run_posting_flag, 'N') RUN_POSTING_FLAG, NVL(CONS.summarize_lines_flag, 'Y') SUMMARIZE_LINES_FLAG, NVL(CONS.audit_mode_flag, 'N') AUDIT_MODE_FLAG, CONS.method METHOD_CODE, L.meaning METHOD_MEANING, LGR.currency_code CURRENCY_CODE, LGR.consolidation_ledger_flag CONS_LEDGER_FLAG, LGR.enable_average_balances_flag ADB_FLAG, LGR.period_set_name CALENDAR, LGR.accounted_period_type PERIOD_TYPE, LGR.short_name TO_SHORT_NAME, LGR.name TO_LEDGER_NAME, LGR.description TO_LEDGER_DESC, decode(CONS.security_flag,'Y', decode(fnd_data_security.check_function(1.0,'GL_DAS_CONSOLIDATION_SET_V', 'GL_DAS_CONSOLIDATION_SET', to_char(CONS.consolidation_set_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') VIEW_PRIVILEGE, decode(CONS.security_flag,'Y', decode(fnd_data_security.check_function(1.0,'GL_DAS_CONSOLIDATION_SET_U', 'GL_DAS_CONSOLIDATION_SET', to_char(CONS.consolidation_set_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') USE_PRIVILEGE, decode(CONS.security_flag,'Y', decode(fnd_data_security.check_function(1.0,'GL_DAS_CONSOLIDATION_SET_M', 'GL_DAS_CONSOLIDATION_SET', to_char(CONS.consolidation_set_id), null, null, null, null, fnd_global.user_name), 'T', 'Y', 'N'), 'Y') MODIFY_PRIVILEGE FROM GL_LOOKUPS L, GL_LEDGERS LGR, GL_CONSOLIDATION_SETS CONS WHERE CONS.to_ledger_id = LGR.ledger_id AND L.lookup_type = 'CONSOLIDATION_METHOD' AND L.lookup_code = CONS.method

View Text - HTML Formatted

SELECT CONS.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID
, CONS.NAME CONS_SET_NAME
, CONS.DESCRIPTION DESCRIPTION
, CONS.TO_LEDGER_ID TO_LEDGER_ID
, NVL(CONS.RUN_JOURNAL_IMPORT_FLAG
, 'Y') JOURNAL_IMPORT_FLAG
, NVL(CONS.RUN_POSTING_FLAG
, 'N') RUN_POSTING_FLAG
, NVL(CONS.SUMMARIZE_LINES_FLAG
, 'Y') SUMMARIZE_LINES_FLAG
, NVL(CONS.AUDIT_MODE_FLAG
, 'N') AUDIT_MODE_FLAG
, CONS.METHOD METHOD_CODE
, L.MEANING METHOD_MEANING
, LGR.CURRENCY_CODE CURRENCY_CODE
, LGR.CONSOLIDATION_LEDGER_FLAG CONS_LEDGER_FLAG
, LGR.ENABLE_AVERAGE_BALANCES_FLAG ADB_FLAG
, LGR.PERIOD_SET_NAME CALENDAR
, LGR.ACCOUNTED_PERIOD_TYPE PERIOD_TYPE
, LGR.SHORT_NAME TO_SHORT_NAME
, LGR.NAME TO_LEDGER_NAME
, LGR.DESCRIPTION TO_LEDGER_DESC
, DECODE(CONS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CONSOLIDATION_SET_V'
, 'GL_DAS_CONSOLIDATION_SET'
, TO_CHAR(CONS.CONSOLIDATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') VIEW_PRIVILEGE
, DECODE(CONS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CONSOLIDATION_SET_U'
, 'GL_DAS_CONSOLIDATION_SET'
, TO_CHAR(CONS.CONSOLIDATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') USE_PRIVILEGE
, DECODE(CONS.SECURITY_FLAG
, 'Y'
, DECODE(FND_DATA_SECURITY.CHECK_FUNCTION(1.0
, 'GL_DAS_CONSOLIDATION_SET_M'
, 'GL_DAS_CONSOLIDATION_SET'
, TO_CHAR(CONS.CONSOLIDATION_SET_ID)
, NULL
, NULL
, NULL
, NULL
, FND_GLOBAL.USER_NAME)
, 'T'
, 'Y'
, 'N')
, 'Y') MODIFY_PRIVILEGE
FROM GL_LOOKUPS L
, GL_LEDGERS LGR
, GL_CONSOLIDATION_SETS CONS
WHERE CONS.TO_LEDGER_ID = LGR.LEDGER_ID
AND L.LOOKUP_TYPE = 'CONSOLIDATION_METHOD'
AND L.LOOKUP_CODE = CONS.METHOD