Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | APPS.GL_LEDGER_SET_ASSIGNMENTS_V |
SELECT LSA.ROWID ROW_ID
, LSA.LEDGER_SET_ID LEDGER_SET_ID
, LDG.LEDGER_ID LEDGER_ID
, LDG.BAL_SEG_VALUE_OPTION_CODE BAL_SEG_VALUE_OPTION_CODE
, LDG.MGT_SEG_VALUE_OPTION_CODE MGT_SEG_VALUE_OPTION_CODE
, LSV.SEGMENT_TYPE_CODE SEGMENT_TYPE_CODE
, LSV.SEGMENT_VALUE SEGMENT_VALUE
, LSA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, LSA.LAST_UPDATED_BY LAST_UPDATED_BY
, LSA.CREATION_DATE CREATION_DATE
, LSA.CREATED_BY CREATED_BY
, LSA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LSA.START_DATE START_DATE
, LSA.END_DATE END_DATE
FROM GL_LEDGER_SET_ASSIGNMENTS LSA
, GL_LEDGERS LDG
, GL_LEDGER_SEGMENT_VALUES LSV
WHERE LDG.LEDGER_ID = LSA.LEDGER_ID(+) AND LDG.LEDGER_ID = LSV.LEDGER_ID(+)