View: GL_IEA_RECUR_BATCHES_V

View Text

SELECT B.ROWID ROW_ID
, B.RECURRING_BATCH_ID RECURRING_BATCH_ID
, S.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, B.NAME NAME
, B.SENDING_SUBSIDIARY_ID SENDING_SUBSIDIARY_ID
, S.NAME SENDING_SUBSIDIARY
, S.COMPANY_VALUE SENDER_COMPANY_VALUE
, S.CURRENCY_CODE DEFAULT_CURRENCY_CODE
, S.SUBSIDIARY_TYPE_CODE SUBSIDIARY_TYPE_CODE
, S.AUTO_APPROVE_FLAG AUTO_APPROVE_FLAG
, B.AUTOSELECT_FLAG AUTOSELECT_FLAG
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, B.DESCRIPTION DESCRIPTION
, B.LAST_EXECUTED_BY LAST_EXECUTED_BY
, U.USER_NAME LAST_EXECUTED_BY_NAME
, B.LAST_EXECUTED_GL_DATE LAST_EXECUTED_GL_DATE
, B.CONTEXT CONTEXT
, B.ATTRIBUTE1 ATTRIBUTE1
, B.ATTRIBUTE2 ATTRIBUTE2
, B.ATTRIBUTE3 ATTRIBUTE3
, B.ATTRIBUTE4 ATTRIBUTE4
, B.ATTRIBUTE5 ATTRIBUTE5
, B.ATTRIBUTE6 ATTRIBUTE6
, B.ATTRIBUTE7 ATTRIBUTE7
, B.ATTRIBUTE8 ATTRIBUTE8
, B.ATTRIBUTE9 ATTRIBUTE9
, B.ATTRIBUTE10 ATTRIBUTE10
, B.ATTRIBUTE11 ATTRIBUTE11
, B.ATTRIBUTE12 ATTRIBUTE12
, B.ATTRIBUTE13 ATTRIBUTE13
, B.ATTRIBUTE14 ATTRIBUTE14
, B.ATTRIBUTE15 ATTRIBUTE15
FROM GL_IEA_RECUR_BATCHES B
, GL_IEA_SUBSIDIARIES S
, FND_USER U
WHERE B.SENDING_SUBSIDIARY_ID = S.SUBSIDIARY_ID
AND U.USER_ID (+) = B.LAST_EXECUTED_BY

Columns