Product: | GL - General Ledger |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT GLOBAL_INTERCO_TRAN.TRANSACTION_ID
, GLOBAL_INTERCO_TRAN_TYPE.NAME
, GLOBAL_INTERCO_TRAN.CURRENCY_CODE
, GLOBAL_INTERCO_TRAN.TRANSACTION_NUMBER
, GLOBAL_INTERCO_TRAN.SENDING_SUBSIDIARY_ID
, GLOBAL_INTERCO_SUB.NAME
, GLOBAL_INTERCO_TRAN.STATUS
, GLOBAL_INTERCO_TRAN.SENDER_CLEARING_CCID
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT1
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT2
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT3
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT4
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT5
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT6
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT7
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT8
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT9
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT10
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT11
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT12
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT13
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT14
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT15
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT16
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT17
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT18
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT19
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT20
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT21
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT22
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT23
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT24
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT25
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT26
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT27
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT28
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT29
, GLOBAL_INTERCO_TRAN.SENDER_SEGMENT30
, GLOBAL_INTERCO_TRAN.CONTEXT
, GLOBAL_INTERCO_TRAN.ATTRIBUTE1
, GLOBAL_INTERCO_TRAN.ATTRIBUTE2
, GLOBAL_INTERCO_TRAN.ATTRIBUTE3
, GLOBAL_INTERCO_TRAN.ATTRIBUTE4
, GLOBAL_INTERCO_TRAN.ATTRIBUTE5
, GLOBAL_INTERCO_TRAN.ATTRIBUTE6
, GLOBAL_INTERCO_TRAN.ATTRIBUTE7
, GLOBAL_INTERCO_TRAN.ATTRIBUTE8
, GLOBAL_INTERCO_TRAN.ATTRIBUTE9
, GLOBAL_INTERCO_TRAN.ATTRIBUTE10
, GLOBAL_INTERCO_TRAN.ATTRIBUTE11
, GLOBAL_INTERCO_TRAN.ATTRIBUTE12
, GLOBAL_INTERCO_TRAN.ATTRIBUTE13
, GLOBAL_INTERCO_TRAN.ATTRIBUTE14
, GLOBAL_INTERCO_TRAN.ATTRIBUTE15
, GLOBAL_INTERCO_TRAN.GL_DATE
, GLOBAL_INTERCO_TRAN.ENTERED_DATE
, GLOBAL_INTERCO_TRAN.SENDER_TRANSFER_FLAG
, GLOBAL_INTERCO_TRAN.SENDER_PERIOD_NAME
, GLOBAL_INTERCO_TRAN.SENDER_RUNNING_TOTAL_DR
, GLOBAL_INTERCO_TRAN.SENDER_RUNNING_TOTAL_CR
, GLOBAL_INTERCO_TRAN.CONTROL_TOTAL
, GLOBAL_INTERCO_TRAN.APPROVED_DATE
, GLOBAL_INTERCO_TRAN.DESCRIPTION
, GLOBAL_INTERCO_TRAN.NOTE
, GLOBAL_INTERCO_SUB.CHART_OF_ACCOUNTS_ID
FROM GL_IEA_TRANSACTIONS GLOBAL_INTERCO_TRAN
, GL_IEA_TRANSACTION_TYPES GLOBAL_INTERCO_TRAN_TYPE
, GL_IEA_SUBSIDIARIES GLOBAL_INTERCO_SUB
WHERE GLOBAL_INTERCO_TRAN.SENDING_SUBSIDIARY_ID= GLOBAL_INTERCO_SUB.SUBSIDIARY_ID
AND GLOBAL_INTERCO_TRAN.TRANSACTION_TYPE_ID = GLOBAL_INTERCO_TRAN_TYPE.TRANSACTION_TYPE_ID WITH READ ONLY