Support #11768
[SCP ID :##5847##] : Select query for IBG ( corus report)
Status: | Closed - End of life cycle | Start date: | May 06, 2021 | |
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | Zahir Abd Latif | % Done: | 100% | |
Category: | MY CORUS | Spent time: | - | |
Target version: | - |
Description
Hi,
Kindly attend below request:-
Can we have the select query for below reports in Corus?
IBG Originating Transaction Enquiry
IBG Receiving Transaction Enquiry
History
#1 Updated by Zahir Abd Latif over 3 years ago
- Status changed from New - Begin Life Cycle to Closed - End of life cycle
- Assignee changed from Hafizudin MD to Zahir Abd Latif
- % Done changed from 0 to 100
Hafiz, May 17, 2021 09:40 AM:-
Select * from ibg_entry where to_date('01/01/2021','dd/mm/yyyy') <= trunc(creation_date) and to_date('01/05/2021','dd/mm/yyyy') >= trunc(creation_date); Select * from ibg_return_entry join ibg_rfi on ibg_return_entry.receive_trnx_id=ibg_rfi.receive_trnx_id where to_date('01/01/2021','dd/mm/yyyy') <= trunc(processed_date) and to_date('01/05/2021','dd/mm/yyyy') >= trunc(processed_date) and receive_trnx_id is not null; Select * from ibg_rfi join ibg_crediting on ibg_rfi.receive_trnx_id=ibg_crediting.receive_trnx_id where to_date('01/01/2021','dd/mm/yyyy') <= trunc(creation_date) and to_date('01/05/2021','dd/mm/yyyy') >= trunc(creation_date) and receive_trnx_id is not null;
Verified by Norashikin.
Issue closed in SCP.