View: GL_CONS_SET_ASSIGN_V

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

View Text

SELECT CSA.ROWID ROW_ID
, CSA.CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID
, CSA.CONSOLIDATION_ID CONSOLIDATION_ID
, CSA.CREATION_DATE CREATION_DATE
, CSA.CREATED_BY CREATED_BY
, CSA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CSA.LAST_UPDATED_BY LAST_UPDATED_BY
, CSA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CST.NAME CHILD_CONS_SET_NAME
, CST.CONSOLIDATION_SET_ID CHILD_CONS_SET_ID
, CSA.CONTEXT CONTEXT
, CONS.NAME CONSOLIDATION_NAME
, CONS.DESCRIPTION CONSOLIDATION_DESCRIPTION
, GL_FC_XLATE_PKG.GET_LEDGER_NAME(LEDGER.NAME
, LEDGER.LEDGER_ID
, CONS.FROM_CURRENCY_CODE) SUBSIDIARY_LEDGER_NAME
, LEDGER.LEDGER_ID SUBSIDIARY_LEDGER_ID
, CSA.ATTRIBUTE1 ATTRIBUTE1
, CSA.ATTRIBUTE2 ATTRIBUTE2
, CSA.ATTRIBUTE3 ATTRIBUTE3
, CSA.ATTRIBUTE4 ATTRIBUTE4
, CSA.ATTRIBUTE5 ATTRIBUTE5
, CSA.ATTRIBUTE6 ATTRIBUTE6
, CSA.ATTRIBUTE7 ATTRIBUTE7
, CSA.ATTRIBUTE8 ATTRIBUTE8
, CSA.ATTRIBUTE9 ATTRIBUTE9
, CSA.ATTRIBUTE10 ATTRIBUTE10
, CSA.ATTRIBUTE11 ATTRIBUTE11
, CSA.ATTRIBUTE12 ATTRIBUTE12
, CSA.ATTRIBUTE13 ATTRIBUTE13
, CSA.ATTRIBUTE14 ATTRIBUTE14
, CSA.ATTRIBUTE15 ATTRIBUTE15 FROM GL_CONSOLIDATION_SETS CST
, GL_LEDGERS LEDGER
, GL_CONSOLIDATION CONS
, GL_CONS_SET_ASSIGNMENTS CSA
WHERE CSA.CONSOLIDATION_ID = CONS.CONSOLIDATION_ID AND CONS.FROM_LEDGER_ID = LEDGER.LEDGER_ID AND CST.CONSOLIDATION_SET_ID (+)= CSA.CHILD_CONSOLIDATION_SET_ID

Columns