View: GL_IEA_AUTOGEN_MAP_V

View Text

SELECT MAP.ROWID ROW_ID
, MAP.SENDER_CHART_OF_ACCT_ID SENDER_CHART_OF_ACCT_ID
, FD1.ID_FLEX_STRUCTURE_NAME SENDER_CHART_OF_ACCT_NAME
, MAP.RECEIVER_CHART_OF_ACCT_ID RECEIVER_CHART_OF_ACCT_ID
, FD2.ID_FLEX_STRUCTURE_NAME RECEIVER_CHART_OF_ACCT_NAME
, MAP.USE_SENDER_CLEAR_RULES_FLAG USE_SENDER_CLEAR_RULES_FLAG
, MAP.USE_RECEIVER_CLEAR_RULES_FLAG USE_RECEIVER_CLEAR_RULES_FLAG
, MAP.USE_RECEIVER_DIST_RULES_FLAG USE_RECEIVER_DIST_RULES_FLAG
, MAP.LAST_UPDATE_DATE LAST_UPDATE_DATE
, MAP.LAST_UPDATED_BY LAST_UPDATED_BY
, MAP.CREATION_DATE CREATION_DATE
, MAP.CREATED_BY CREATED_BY
, MAP.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, MAP.ATTRIBUTE1 ATTRIBUTE1
, MAP.ATTRIBUTE2 ATTRIBUTE2
, MAP.ATTRIBUTE3 ATTRIBUTE3
, MAP.ATTRIBUTE4 ATTRIBUTE4
, MAP.ATTRIBUTE5 ATTRIBUTE5
, MAP.ATTRIBUTE6 ATTRIBUTE6
, MAP.ATTRIBUTE7 ATTRIBUTE7
, MAP.ATTRIBUTE8 ATTRIBUTE8
, MAP.ATTRIBUTE9 ATTRIBUTE9
, MAP.ATTRIBUTE10 ATTRIBUTE10
, MAP.ATTRIBUTE11 ATTRIBUTE11
, MAP.ATTRIBUTE12 ATTRIBUTE12
, MAP.ATTRIBUTE13 ATTRIBUTE13
, MAP.ATTRIBUTE14 ATTRIBUTE14
, MAP.ATTRIBUTE15 ATTRIBUTE15
, MAP.CONTEXT CONTEXT
FROM GL_IEA_AUTOGEN_MAP MAP
, FND_ID_FLEX_STRUCTURES_VL FD1
, FND_ID_FLEX_STRUCTURES_VL FD2
WHERE FD1.APPLICATION_ID = 101
AND FD1.ID_FLEX_CODE = 'GL#'
AND FD1.ID_FLEX_NUM = MAP.SENDER_CHART_OF_ACCT_ID
AND FD2.APPLICATION_ID = 101
AND FD2.ID_FLEX_CODE = 'GL#'
AND FD2.ID_FLEX_NUM = MAP.RECEIVER_CHART_OF_ACCT_ID

Columns