Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT SEG.ROWID ROW_ID
, SEG.SEGMENT_MAP_ID SEGMENT_MAP_ID
, SEG.GENERATE_TYPE_CODE GENERATE_TYPE_CODE
, SEG.SENDER_CHART_OF_ACCT_ID SENDER_CHART_OF_ACCT_ID
, SEG.RECEIVER_CHART_OF_ACCT_ID RECEIVER_CHART_OF_ACCT_ID
, SEG.TO_APPLICATION_COLUMN_NAME TO_APPLICATION_COLUMN_NAME
, FD1.SEGMENT_NAME TO_SEGMENT_NAME
, FD1.SEGMENT_NUM TO_SEGMENT_NUM
, SEG.SEGMENT_MAP_TYPE_CODE SEGMENT_MAP_TYPE_CODE
, SEG.LAST_UPDATE_DATE LAST_UPDATE_DATE
, SEG.LAST_UPDATED_BY LAST_UPDATED_BY
, SEG.CREATION_DATE CREATION_DATE
, SEG.CREATED_BY CREATED_BY
, SEG.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SEG.FROM_APPLICATION_COLUMN_NAME FROM_APPLICATION_COLUMN_NAME
, DECODE(GENERATE_TYPE_CODE
, 'SC'
, ''
, FD2.SEGMENT_NAME) FROM_SEGMENT_NAME
, DECODE(GENERATE_TYPE_CODE
, 'SC'
, ''
, FD2.SEGMENT_NUM) FROM_SEGMENT_NUM
, SEG.SINGLE_VALUE SINGLE_VALUE
, SEG.ATTRIBUTE1 ATTRIBUTE1
, SEG.ATTRIBUTE2 ATTRIBUTE2
, SEG.ATTRIBUTE3 ATTRIBUTE3
, SEG.ATTRIBUTE4 ATTRIBUTE4
, SEG.ATTRIBUTE5 ATTRIBUTE5
, SEG.ATTRIBUTE6 ATTRIBUTE6
, SEG.ATTRIBUTE7 ATTRIBUTE7
, SEG.ATTRIBUTE8 ATTRIBUTE8
, SEG.ATTRIBUTE9 ATTRIBUTE9
, SEG.ATTRIBUTE10 ATTRIBUTE10
, SEG.ATTRIBUTE11 ATTRIBUTE11
, SEG.ATTRIBUTE12 ATTRIBUTE12
, SEG.ATTRIBUTE13 ATTRIBUTE13
, SEG.ATTRIBUTE14 ATTRIBUTE14
, SEG.ATTRIBUTE15 ATTRIBUTE15
, SEG.CONTEXT CONTEXT
FROM GL_IEA_SEGMENT_MAP SEG
, FND_ID_FLEX_SEGMENTS FD1
, FND_ID_FLEX_SEGMENTS FD2
WHERE FD1.APPLICATION_ID = 101
AND FD1.ID_FLEX_CODE = 'GL#'
AND FD1.ID_FLEX_NUM = DECODE(SEG.GENERATE_TYPE_CODE
, 'SC'
, SEG.SENDER_CHART_OF_ACCT_ID
, SEG.RECEIVER_CHART_OF_ACCT_ID)
AND FD1.APPLICATION_COLUMN_NAME = SEG.TO_APPLICATION_COLUMN_NAME
AND FD2.APPLICATION_ID(+) = 101
AND FD2.ID_FLEX_CODE(+) = 'GL#'
AND FD2.ID_FLEX_NUM(+) = SEG.SENDER_CHART_OF_ACCT_ID
AND FD2.APPLICATION_COLUMN_NAME(+) = SEG.FROM_APPLICATION_COLUMN_NAME