FND Design Data [Home] [Help]

View: GL_IEA_TRANSACTIONS_V

Product: GL - General Ledger
Description:
Implementation/DBA Data: Not implemented in this database
View Text

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

Columns

Name
ROW_ID
TRANSACTION_ID
CHART_OF_ACCOUNTS_ID
RECEIVER_COA_ID
TRANSACTION_TYPE_ID
CURRENCY_CODE
TRANSACTION_NUMBER
SENDING_SUBSIDIARY_ID
RECEIVING_SUBSIDIARY_ID
STATUS
SENDER_CLEARING_CCID
RECEIVER_CLEARING_CCID
GL_DATE
ENTERED_DATE
SENDER_TRANSFER_FLAG
RECEIVER_TRANSFER_FLAG
SENDER_PERIOD_NAME
RECEIVER_PERIOD_NAME
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
SENDER_GENERATION_CODE
RECEIVER_GENERATION_CODE
SENDER_SEGMENT1
SENDER_SEGMENT2
SENDER_SEGMENT3
SENDER_SEGMENT4
SENDER_SEGMENT5
SENDER_SEGMENT6
SENDER_SEGMENT7
SENDER_SEGMENT8
SENDER_SEGMENT9
SENDER_SEGMENT10
SENDER_SEGMENT11
SENDER_SEGMENT12
SENDER_SEGMENT13
SENDER_SEGMENT14
SENDER_SEGMENT15
SENDER_SEGMENT16
SENDER_SEGMENT17
SENDER_SEGMENT18
SENDER_SEGMENT19
SENDER_SEGMENT20
SENDER_SEGMENT21
SENDER_SEGMENT22
SENDER_SEGMENT23
SENDER_SEGMENT24
SENDER_SEGMENT25
SENDER_SEGMENT26
SENDER_SEGMENT27
SENDER_SEGMENT28
SENDER_SEGMENT29
SENDER_SEGMENT30
RECEIVER_SEGMENT1
RECEIVER_SEGMENT2
RECEIVER_SEGMENT3
RECEIVER_SEGMENT4
RECEIVER_SEGMENT5
RECEIVER_SEGMENT6
RECEIVER_SEGMENT7
RECEIVER_SEGMENT8
RECEIVER_SEGMENT9
RECEIVER_SEGMENT10
RECEIVER_SEGMENT11
RECEIVER_SEGMENT12
RECEIVER_SEGMENT13
RECEIVER_SEGMENT14
RECEIVER_SEGMENT15
RECEIVER_SEGMENT16
RECEIVER_SEGMENT17
RECEIVER_SEGMENT18
RECEIVER_SEGMENT19
RECEIVER_SEGMENT20
RECEIVER_SEGMENT21
RECEIVER_SEGMENT22
RECEIVER_SEGMENT23
RECEIVER_SEGMENT24
RECEIVER_SEGMENT25
RECEIVER_SEGMENT26
RECEIVER_SEGMENT27
RECEIVER_SEGMENT28
RECEIVER_SEGMENT29
RECEIVER_SEGMENT30
SND_RUNNING_TOTAL_DR
SND_RUNNING_TOTAL_CR
RCR_RUNNING_TOTAL_DR
RCR_RUNNING_TOTAL_CR
CONTROL_TOTAL
APPROVED_DATE
DESCRIPTION
NOTE
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
TYPE_NAME
TYPE_AUTO_APPROVE
SENDER_NAME
SENDER_SET_OF_BOOKS_ID
SENDER_COMPANY_VALUE
RECEIVER_NAME
RECEIVER_SET_OF_BOOKS_ID
RECEIVER_COMPANY_VALUE
REVERSE_TRANSACTION_ID
REVERSED_FLAG
SENDER_VIEW_PARTNER
RECEIVER_VIEW_PARTNER