Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT T.ROWID ROW_ID
, T.RECURRING_TRANSACTION_ID RECURRING_TRANSACTION_ID
, T.RECURRING_BATCH_ID RECURRING_BATCH_ID
, T.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, R.NAME TRANSACTION_TYPE
, R.AUTO_APPROVE_FLAG AUTO_APPROVE_FLAG
, T.CURRENCY_CODE CURRENCY_CODE
, T.NAME NAME
, T.RECEIVING_SUBSIDIARY_ID RECEIVING_SUBSIDIARY_ID
, T.RECEIVER_COA_ID RECEIVER_COA_ID
, S.NAME RECEIVING_SUBSIDIARY
, T.STATUS STATUS
, L.MEANING STATUS_MEANING
, S.COMPANY_VALUE RECEIVER_COMPANY_VALUE
, T.SENDER_CLEARING_CCID SENDER_CLEARING_CCID
, T.RECEIVER_CLEARING_CCID RECEIVER_CLEARING_CCID
, T.SENDER_CLEARING_ACCOUNT SENDER_CLEARING_NATURAL_SEG
, T.RECEIVER_CLEARING_ACCOUNT RECEIVER_CLEARING_NATURAL_SEG
, T.CREATION_DATE CREATION_DATE
, T.CREATED_BY CREATED_BY
, T.LAST_UPDATE_DATE LAST_UPDATE_DATE
, T.LAST_UPDATED_BY LAST_UPDATED_BY
, T.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, T.SENDER_RUNNING_TOTAL_DR SND_RUNNING_TOTAL_DR
, T.SENDER_RUNNING_TOTAL_CR SND_RUNNING_TOTAL_CR
, T.RECEIVER_RUNNING_TOTAL_DR RCR_RUNNING_TOTAL_DR
, T.RECEIVER_RUNNING_TOTAL_CR RCR_RUNNING_TOTAL_CR
, T.CONTROL_TOTAL CONTROL_TOTAL
, T.DESCRIPTION DESCRIPTION
, T.NOTE NOTE
, T.CONTEXT CONTEXT
, T.ATTRIBUTE1 ATTRIBUTE1
, T.ATTRIBUTE2 ATTRIBUTE2
, T.ATTRIBUTE3 ATTRIBUTE3
, T.ATTRIBUTE4 ATTRIBUTE4
, T.ATTRIBUTE5 ATTRIBUTE5
, T.ATTRIBUTE6 ATTRIBUTE6
, T.ATTRIBUTE7 ATTRIBUTE7
, T.ATTRIBUTE8 ATTRIBUTE8
, T.ATTRIBUTE9 ATTRIBUTE9
, T.ATTRIBUTE10 ATTRIBUTE10
, T.ATTRIBUTE11 ATTRIBUTE11
, T.ATTRIBUTE12 ATTRIBUTE12
, T.ATTRIBUTE13 ATTRIBUTE13
, T.ATTRIBUTE14 ATTRIBUTE14
, T.ATTRIBUTE15 ATTRIBUTE15
FROM GL_IEA_RECUR_TRANSACTIONS T
, GL_IEA_SUBSIDIARIES S
, GL_IEA_TRANSACTION_TYPES R
, GL_LOOKUPS L
WHERE T.RECEIVING_SUBSIDIARY_ID = S.SUBSIDIARY_ID
AND T.TRANSACTION_TYPE_ID = R.TRANSACTION_TYPE_ID
AND L.LOOKUP_TYPE = 'IEA_TRANSACTION_STATUS'
AND T.STATUS = L.LOOKUP_CODE