View: GLFV_GLOBAL_INTERCO_SUBS

View Text

SELECT GLOBAL_INTERCO_SUB.SUBSIDIARY_ID
, GLOBAL_INTERCO_SUB.NAME
, '_LA:GLOBAL_INTERCO_SUB.SUBSIDIARY_TYPE_CODE:GL_LOOKUPS:SUBSIDIARY_TYPE:MEANING'
, GLOBAL_INTERCO_SUB.CHART_OF_ACCOUNTS_ID
, CHART_OF_ACCOUNTS_TL.ID_FLEX_STRUCTURE_NAME
, GLOBAL_INTERCO_SUB.SET_OF_BOOKS_ID
, GL_SET_OF_BOOKS1.NAME
, GLOBAL_INTERCO_SUB.CURRENCY_CODE
, GLOBAL_INTERCO_SUB.COMPANY_VALUE
, GLOBAL_INTERCO_SUB.DESCRIPTION
, '_LA:GLOBAL_INTERCO_SUB.ENABLED_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GLOBAL_INTERCO_SUB.AUTO_APPROVE_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GLOBAL_INTERCO_SUB.CONVERSION_TYPE_CODE:GL_LOOKUPS:CONVERSION_RATE_TYPE:MEANING'
, GLOBAL_INTERCO_SUB.CONVERSION_TYPE
, GL_CONVERSION_TYPE.USER_CONVERSION_TYPE
, NOTIFICATION_THRESHOLD
, TRANSFER_CURRENCY_CODE
, '_LA:GLOBAL_INTERCO_SUB.REMOTE_INSTANCE_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, '_LA:GLOBAL_INTERCO_SUB.VIEW_PARTNER_LINES_FLAG:GL_LOOKUPS:YES/NO:MEANING'
, TRANSFER_SET_OF_BOOKS_ID
, DECODE(GLOBAL_INTERCO_SUB.TRANSFER_SET_OF_BOOKS_ID
, -1
, NULL
, GL_SET_OF_BOOKS2.NAME)
, '_DF:SQLGL:GL_IEA_SUBSIDIARIES:GLOBAL_INTERCO_SUB'
FROM GL_IEA_SUBSIDIARIES GLOBAL_INTERCO_SUB
, GL_SETS_OF_BOOKS GL_SET_OF_BOOKS1
, GL_SETS_OF_BOOKS GL_SET_OF_BOOKS2
, GL_DAILY_CONVERSION_TYPES GL_CONVERSION_TYPE
, FND_ID_FLEX_STRUCTURES_TL CHART_OF_ACCOUNTS_TL
WHERE (GLOBAL_INTERCO_SUB.SET_OF_BOOKS_ID = GL_SET_OF_BOOKS1.SET_OF_BOOKS_ID)
AND (GLOBAL_INTERCO_SUB.CHART_OF_ACCOUNTS_ID = GL_SET_OF_BOOKS1.CHART_OF_ACCOUNTS_ID)
AND (GLOBAL_INTERCO_SUB.CHART_OF_ACCOUNTS_ID = CHART_OF_ACCOUNTS_TL.ID_FLEX_NUM)
AND (CHART_OF_ACCOUNTS_TL.APPLICATION_ID = 101)
AND (CHART_OF_ACCOUNTS_TL.ID_FLEX_CODE = 'GL#')
AND (CHART_OF_ACCOUNTS_TL.LANGUAGE = USERENV('LANG'))
AND (GLOBAL_INTERCO_SUB.CONVERSION_TYPE = GL_CONVERSION_TYPE.CONVERSION_TYPE(+))
AND (GLOBAL_INTERCO_SUB.TRANSFER_SET_OF_BOOKS_ID= GL_SET_OF_BOOKS2.SET_OF_BOOKS_ID(+)) WITH READ ONLY

Columns