VIEW: APPS.GL_CONS_SET_ASSIGNMENTS_V

Source

View Text - Preformatted

SELECT CONS.rowid ROW_ID, SETS.consolidation_set_id CONSOLIDATION_SET_ID, CONS.consolidation_id CONSOLIDATION_ID, CONS.name NAME, CONS.description DESCRIPTION, CONS.method METHOD_CODE, L.meaning METHOD_MEANING, CONS.from_ledger_id FROM_LEDGER_ID, gl_fc_xlate_pkg.get_ledger_short_name ( ledger.short_name, ledger.ledger_id, cons.from_currency_code ) FROM_SHORT_NAME, gl_fc_xlate_pkg.get_ledger_name ( ledger.name, ledger.ledger_id, cons.from_currency_code ) FROM_LEDGER_NAME, LEDGER.chart_of_accounts_id FROM_CHART_OF_ACCOUNTS_ID, LEDGER.enable_average_balances_flag ADB_ENABLED_FLAG, LEDGER.period_set_name CALENDAR, LEDGER.accounted_period_type PERIOD_TYPE, CONS.from_currency_code FROM_CURRENCY_CODE, MAP.start_date_active START_DATE_ACTIVE, MAP.end_date_active END_DATE_ACTIVE FROM GL_LOOKUPS L, GL_LEDGERS LEDGER, GL_CONSOLIDATION CONS, GL_COA_MAPPINGS MAP, GL_CONS_SET_ASSIGNMENTS SETS WHERE SETS.consolidation_id = CONS.consolidation_id AND CONS.from_ledger_id = LEDGER.ledger_id AND L.lookup_type = 'CONSOLIDATION_METHOD' AND L.lookup_code = CONS.method AND CONS.coa_mapping_id = MAP.coa_mapping_id

View Text - HTML Formatted

SELECT CONS.ROWID ROW_ID
, SETS.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID
, CONS.CONSOLIDATION_ID CONSOLIDATION_ID
, CONS.NAME NAME
, CONS.DESCRIPTION DESCRIPTION
, CONS.METHOD METHOD_CODE
, L.MEANING METHOD_MEANING
, CONS.FROM_LEDGER_ID FROM_LEDGER_ID
, GL_FC_XLATE_PKG.GET_LEDGER_SHORT_NAME ( LEDGER.SHORT_NAME
, LEDGER.LEDGER_ID
, CONS.FROM_CURRENCY_CODE ) FROM_SHORT_NAME
, GL_FC_XLATE_PKG.GET_LEDGER_NAME ( LEDGER.NAME
, LEDGER.LEDGER_ID
, CONS.FROM_CURRENCY_CODE ) FROM_LEDGER_NAME
, LEDGER.CHART_OF_ACCOUNTS_ID FROM_CHART_OF_ACCOUNTS_ID
, LEDGER.ENABLE_AVERAGE_BALANCES_FLAG ADB_ENABLED_FLAG
, LEDGER.PERIOD_SET_NAME CALENDAR
, LEDGER.ACCOUNTED_PERIOD_TYPE PERIOD_TYPE
, CONS.FROM_CURRENCY_CODE FROM_CURRENCY_CODE
, MAP.START_DATE_ACTIVE START_DATE_ACTIVE
, MAP.END_DATE_ACTIVE END_DATE_ACTIVE
FROM GL_LOOKUPS L
, GL_LEDGERS LEDGER
, GL_CONSOLIDATION CONS
, GL_COA_MAPPINGS MAP
, GL_CONS_SET_ASSIGNMENTS SETS
WHERE SETS.CONSOLIDATION_ID = CONS.CONSOLIDATION_ID
AND CONS.FROM_LEDGER_ID = LEDGER.LEDGER_ID
AND L.LOOKUP_TYPE = 'CONSOLIDATION_METHOD'
AND L.LOOKUP_CODE = CONS.METHOD
AND CONS.COA_MAPPING_ID = MAP.COA_MAPPING_ID