View: GL_IEA_SUBSIDIARIES_V

View Text

SELECT SUB.ROWID ROW_ID
, SUB.NAME
, SUB.DESCRIPTION
, SOB.NAME SET_OF_BOOKS_NAME
, SUB.CURRENCY_CODE
, SUB.COMPANY_VALUE
, SUB.ENABLED_FLAG
, SUB.SUBSIDIARY_TYPE_CODE
, SUB.AUTO_APPROVE_FLAG
, SUB.CONVERSION_TYPE_CODE
, TYP.USER_CONVERSION_TYPE
, SUB.CONVERSION_TYPE
, SUB.VIEW_PARTNER_LINES_FLAG
, SUB.SUBSIDIARY_ID
, SUB.CHART_OF_ACCOUNTS_ID
, FLEXV.ID_FLEX_STRUCTURE_NAME CHART_OF_ACCOUNTS_NAME
, SUB.SET_OF_BOOKS_ID
, SUB.REMOTE_INSTANCE_FLAG
, SUB.TRANSFER_SET_OF_BOOKS_ID
, SOB2.NAME TRANSFER_SET_OF_BOOKS_NAME
, SUB.TRANSFER_CURRENCY_CODE
, SUB.CREATION_DATE
, SUB.CREATED_BY
, SUB.LAST_UPDATE_DATE
, SUB.LAST_UPDATED_BY
, SUB.LAST_UPDATE_LOGIN
, SUBSTRB(GL_AUTO_ALLOC_VW_PKG.GET_OWNER_DSP(SUB.CONTACT)
, 1
, 240) CONTACT_DISPLAY_NAME
, SUB.CONTACT
, SUB.NOTIFICATION_THRESHOLD
, SUB.CONTEXT
, SUB.ATTRIBUTE1
, SUB.ATTRIBUTE2
, SUB.ATTRIBUTE3
, SUB.ATTRIBUTE4
, SUB.ATTRIBUTE5
, SUB.ATTRIBUTE6
, SUB.ATTRIBUTE7
, SUB.ATTRIBUTE8
, SUB.ATTRIBUTE9
, SUB.ATTRIBUTE10
, SUB.ATTRIBUTE11
, SUB.ATTRIBUTE12
, SUB.ATTRIBUTE13
, SUB.ATTRIBUTE14
, SUB.ATTRIBUTE15
FROM GL_IEA_SUBSIDIARIES SUB
, GL_SETS_OF_BOOKS SOB
, GL_SETS_OF_BOOKS SOB2
, FND_ID_FLEX_STRUCTURES_V FLEXV
, GL_DAILY_CONVERSION_TYPES TYP
WHERE SOB.SET_OF_BOOKS_ID = SUB.SET_OF_BOOKS_ID
AND SOB2.SET_OF_BOOKS_ID(+) = SUB.TRANSFER_SET_OF_BOOKS_ID
AND TYP.CONVERSION_TYPE = SUB.CONVERSION_TYPE
AND FLEXV.APPLICATION_ID = 101
AND FLEXV.ID_FLEX_CODE = 'GL#'
AND FLEXV.ID_FLEX_NUM = SUB.CHART_OF_ACCOUNTS_ID

Columns