SELECT c.bank_account_num,
a.statement_number,
a.statement_date,
a.creation_date,
a.GL_Date,
b.TRX_Date,
b.trx_type,
b.Amount,
b.Status,
b.Bank_trx_number,
b.trx_text,
b.customer_text,
b.bank_account_text,
b.Invoice_text,
b.Original_amount,
b.charges_Amount,
b.trx_code
FROM apps.CE_STATEMENT_HEADERS a ,
apps.CE_STATEMENT_LINES b ,
apps.ce_bank_accounts c
WHERE c.bank_account_id IN (XXXX)
AND a.statement_header_id = b.statement_header_id
AND a.bank_account_id = c.bank_account_id
ORDER BY a.statement_number
a.statement_number,
a.statement_date,
a.creation_date,
a.GL_Date,
b.TRX_Date,
b.trx_type,
b.Amount,
b.Status,
b.Bank_trx_number,
b.trx_text,
b.customer_text,
b.bank_account_text,
b.Invoice_text,
b.Original_amount,
b.charges_Amount,
b.trx_code
FROM apps.CE_STATEMENT_HEADERS a ,
apps.CE_STATEMENT_LINES b ,
apps.ce_bank_accounts c
WHERE c.bank_account_id IN (XXXX)
AND a.statement_header_id = b.statement_header_id
AND a.bank_account_id = c.bank_account_id
ORDER BY a.statement_number
Nice Blog, I saw Somany unknown topics in this Blog. Thanks For sharing,Keep it up.
ReplyDeleteOracle Fusion HCM Online Training
Oracle Fusion SCM Online Training
Oracle Fusion Financials Online Training
Big Data and Hadoop Training In Hyderabad
Very interesting blog Thank you for sharing such a nice and interesting blog and really very helpful article
ReplyDeleteOracle Fusion HCM Online Training
Thank you for sharing such a nice and interesting blog.
ReplyDeleteOracle Fusion HCM Online Training