Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT TR.ROWID ROW_ID
, TR.TRANSACTION_ID TRANSACTION_ID
, SEND.CHART_OF_ACCOUNTS_ID CHART_OF_ACCOUNTS_ID
, RECV.CHART_OF_ACCOUNTS_ID RECEIVER_COA_ID
, TR.TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
, TR.CURRENCY_CODE CURRENCY_CODE
, TR.TRANSACTION_NUMBER TRANSACTION_NUMBER
, TR.SENDING_SUBSIDIARY_ID SENDING_SUBSIDIARY_ID
, TR.RECEIVING_SUBSIDIARY_ID RECEIVING_SUBSIDIARY_ID
, TR.STATUS STATUS
, TR.SENDER_CLEARING_CCID SENDER_CLEARING_CCID
, TR.RECEIVER_CLEARING_CCID RECEIVER_CLEARING_CCID
, TR.GL_DATE GL_DATE
, TR.ENTERED_DATE ENTERED_DATE
, TR.SENDER_TRANSFER_FLAG SENDER_TRANSFER_FLAG
, TR.RECEIVER_TRANSFER_FLAG RECEIVER_TRANSFER_FLAG
, TR.SENDER_PERIOD_NAME SENDER_PERIOD_NAME
, TR.RECEIVER_PERIOD_NAME RECEIVER_PERIOD_NAME
, TR.CREATION_DATE CREATION_DATE
, TR.CREATED_BY CREATED_BY
, TR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, TR.LAST_UPDATED_BY LAST_UPDATED_BY
, TR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, TR.SENDER_GENERATION_CODE
, TR.RECEIVER_GENERATION_CODE
, TR.SENDER_SEGMENT1
, TR.SENDER_SEGMENT2
, TR.SENDER_SEGMENT3
, TR.SENDER_SEGMENT4
, TR.SENDER_SEGMENT5
, TR.SENDER_SEGMENT6
, TR.SENDER_SEGMENT7
, TR.SENDER_SEGMENT8
, TR.SENDER_SEGMENT9
, TR.SENDER_SEGMENT10
, TR.SENDER_SEGMENT11
, TR.SENDER_SEGMENT12
, TR.SENDER_SEGMENT13
, TR.SENDER_SEGMENT14
, TR.SENDER_SEGMENT15
, TR.SENDER_SEGMENT16
, TR.SENDER_SEGMENT17
, TR.SENDER_SEGMENT18
, TR.SENDER_SEGMENT19
, TR.SENDER_SEGMENT20
, TR.SENDER_SEGMENT21
, TR.SENDER_SEGMENT22
, TR.SENDER_SEGMENT23
, TR.SENDER_SEGMENT24
, TR.SENDER_SEGMENT25
, TR.SENDER_SEGMENT26
, TR.SENDER_SEGMENT27
, TR.SENDER_SEGMENT28
, TR.SENDER_SEGMENT29
, TR.SENDER_SEGMENT30
, TR.RECEIVER_SEGMENT1
, TR.RECEIVER_SEGMENT2
, TR.RECEIVER_SEGMENT3
, TR.RECEIVER_SEGMENT4
, TR.RECEIVER_SEGMENT5
, TR.RECEIVER_SEGMENT6
, TR.RECEIVER_SEGMENT7
, TR.RECEIVER_SEGMENT8
, TR.RECEIVER_SEGMENT9
, TR.RECEIVER_SEGMENT10
, TR.RECEIVER_SEGMENT11
, TR.RECEIVER_SEGMENT12
, TR.RECEIVER_SEGMENT13
, TR.RECEIVER_SEGMENT14
, TR.RECEIVER_SEGMENT15
, TR.RECEIVER_SEGMENT16
, TR.RECEIVER_SEGMENT17
, TR.RECEIVER_SEGMENT18
, TR.RECEIVER_SEGMENT19
, TR.RECEIVER_SEGMENT20
, TR.RECEIVER_SEGMENT21
, TR.RECEIVER_SEGMENT22
, TR.RECEIVER_SEGMENT23
, TR.RECEIVER_SEGMENT24
, TR.RECEIVER_SEGMENT25
, TR.RECEIVER_SEGMENT26
, TR.RECEIVER_SEGMENT27
, TR.RECEIVER_SEGMENT28
, TR.RECEIVER_SEGMENT29
, TR.RECEIVER_SEGMENT30
, TR.SENDER_RUNNING_TOTAL_DR SND_RUNNING_TOTAL_DR
, TR.SENDER_RUNNING_TOTAL_CR SND_RUNNING_TOTAL_CR
, TR.RECEIVER_RUNNING_TOTAL_DR RCR_RUNNING_TOTAL_DR
, TR.RECEIVER_RUNNING_TOTAL_CR RCR_RUNNING_TOTAL_CR
, TR.CONTROL_TOTAL CONTROL_TOTAL
, TR.APPROVED_DATE APPROVED_DATE
, TR.DESCRIPTION DESCRIPTION
, TR.NOTE NOTE
, TR.CONTEXT CONTEXT
, TR.ATTRIBUTE1 ATTRIBUTE1
, TR.ATTRIBUTE2 ATTRIBUTE2
, TR.ATTRIBUTE3 ATTRIBUTE3
, TR.ATTRIBUTE4 ATTRIBUTE4
, TR.ATTRIBUTE5 ATTRIBUTE5
, TR.ATTRIBUTE6 ATTRIBUTE6
, TR.ATTRIBUTE7 ATTRIBUTE7
, TR.ATTRIBUTE8 ATTRIBUTE8
, TR.ATTRIBUTE9 ATTRIBUTE9
, TR.ATTRIBUTE10 ATTRIBUTE10
, TR.ATTRIBUTE11 ATTRIBUTE11
, TR.ATTRIBUTE12 ATTRIBUTE12
, TR.ATTRIBUTE13 ATTRIBUTE13
, TR.ATTRIBUTE14 ATTRIBUTE14
, TR.ATTRIBUTE15 ATTRIBUTE15
, TR.REQUEST_ID REQUEST_ID
, TR.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, TR.PROGRAM_ID PROGRAM_ID
, TR.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TYP.NAME TYPE_NAME
, TYP.AUTO_APPROVE_FLAG TYPE_AUTO_APPROVE
, SEND.NAME SENDER_NAME
, SEND.SET_OF_BOOKS_ID SENDER_SET_OF_BOOKS_ID
, SEND.COMPANY_VALUE SENDER_COMPANY_VALUE
, RECV.NAME RECEIVER_NAME
, RECV.SET_OF_BOOKS_ID RECEIVER_SET_OF_BOOKS_ID
, RECV.COMPANY_VALUE RECEIVER_COMPANY_VALUE
, TR.REVERSE_TRANSACTION_ID REVERSE_TRANSACTION_ID
, DECODE(TR.REVERSE_TRANSACTION_ID
, NULL
, 'N'
, 'Y') REVERSED_FLAG
, SEND.VIEW_PARTNER_LINES_FLAG SENDER_VIEW_PARTNER
, RECV.VIEW_PARTNER_LINES_FLAG RECEIVER_VIEW_PARTNER
FROM GL_IEA_TRANSACTIONS TR
, GL_IEA_TRANSACTION_TYPES TYP
, GL_IEA_SUBSIDIARIES SEND
, GL_IEA_SUBSIDIARIES RECV
WHERE TYP.TRANSACTION_TYPE_ID = TR.TRANSACTION_TYPE_ID AND SEND.SUBSIDIARY_ID = TR.SENDING_SUBSIDIARY_ID
AND RECV.SUBSIDIARY_ID = TR.RECEIVING_SUBSIDIARY_ID