View: GL_IEA_SEGMENT_RULE_MAP_V

View Text

SELECT RUL.ROWID ROW_ID
, RUL.SEGMENT_MAP_ID SEGMENT_MAP_ID
, RUL.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, DECODE(RUL.TRANSACTION_TYPE_ID
, -1
, LK.MEANING
, TYP.NAME) TRANSACTION_TYPE
, RUL.FROM_SUBSIDIARY_ID FROM_SUBSIDIARY_ID
, DECODE(FROM_SUBSIDIARY_ID
, -1
, LK.MEANING
, SUB2.NAME) FROM_SUBSIDIARY
, RUL.TO_SUBSIDIARY_ID TO_SUBSIDIARY_ID
, DECODE(TO_SUBSIDIARY_ID
, -1
, LK.MEANING
, SUB1.NAME) TO_SUBSIDIARY
, RUL.FROM_SEG_VALUE FROM_SEG_VALUE
, RUL.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RUL.LAST_UPDATED_BY LAST_UPDATED_BY
, RUL.CREATION_DATE CREATION_DATE
, RUL.CREATED_BY CREATED_BY
, RUL.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RUL.TO_SEG_VALUE TO_SEG_VALUE
, RUL.ATTRIBUTE1 ATTRIBUTE1
, RUL.ATTRIBUTE2 ATTRIBUTE2
, RUL.ATTRIBUTE3 ATTRIBUTE3
, RUL.ATTRIBUTE4 ATTRIBUTE4
, RUL.ATTRIBUTE5 ATTRIBUTE5
, RUL.ATTRIBUTE6 ATTRIBUTE6
, RUL.ATTRIBUTE7 ATTRIBUTE7
, RUL.ATTRIBUTE8 ATTRIBUTE8
, RUL.ATTRIBUTE9 ATTRIBUTE9
, RUL.ATTRIBUTE10 ATTRIBUTE10
, RUL.ATTRIBUTE11 ATTRIBUTE11
, RUL.ATTRIBUTE12 ATTRIBUTE12
, RUL.ATTRIBUTE13 ATTRIBUTE13
, RUL.ATTRIBUTE14 ATTRIBUTE14
, RUL.ATTRIBUTE15 ATTRIBUTE15
, RUL.CONTEXT CONTEXT
FROM GL_LOOKUPS LK
, GL_IEA_SEGMENT_RULE_MAP RUL
, GL_IEA_TRANSACTION_TYPES TYP
, GL_IEA_SUBSIDIARIES SUB1
, GL_IEA_SUBSIDIARIES SUB2
WHERE TYP.TRANSACTION_TYPE_ID(+) = RUL.TRANSACTION_TYPE_ID
AND SUB1.SUBSIDIARY_ID(+) = RUL.TO_SUBSIDIARY_ID
AND SUB2.SUBSIDIARY_ID(+) = RUL.FROM_SUBSIDIARY_ID
AND LK.LOOKUP_TYPE = 'LITERAL'
AND LK.LOOKUP_CODE = 'OTHER1234567890123456789012345'

Columns