View: GL_CONS_SET_ASSIGNMENTS_V

Product:	GL - General Ledger
Description:
Implementation/DBA Data:	APPS.GL_CONS_SET_ASSIGNMENTS_V

View Text

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

Columns