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.RECEIVING_SUBSIDIARY_ID
, GLOBAL_INTERCO_SUB.NAME
, GLOBAL_INTERCO_TRAN.STATUS
, GLOBAL_INTERCO_TRAN.RECEIVER_CLEARING_CCID
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT1
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT2
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT3
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT4
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT5
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT6
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT7
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT8
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT9
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT10
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT11
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT12
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT13
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT14
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT15
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT16
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT17
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT18
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT19
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT20
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT21
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT22
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT23
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT24
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT25
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT26
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT27
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT28
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT29
, GLOBAL_INTERCO_TRAN.RECEIVER_SEGMENT30
, GLOBAL_INTERCO_TRAN.GL_DATE
, GLOBAL_INTERCO_TRAN.ENTERED_DATE
, GLOBAL_INTERCO_TRAN.RECEIVER_TRANSFER_FLAG
, GLOBAL_INTERCO_TRAN.RECEIVER_PERIOD_NAME
, GLOBAL_INTERCO_TRAN.RECEIVER_RUNNING_TOTAL_DR
, GLOBAL_INTERCO_TRAN.RECEIVER_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.RECEIVING_SUBSIDIARY_ID= GLOBAL_INTERCO_SUB.SUBSIDIARY_ID
AND GLOBAL_INTERCO_TRAN.TRANSACTION_TYPE_ID = GLOBAL_INTERCO_TRAN_TYPE.TRANSACTION_TYPE_ID WITH READ ONLY