Support #11768

[SCP ID :##5847##] : Select query for IBG ( corus report)

Added by Zahir Abd Latif over 3 years ago. Updated over 3 years ago.

Status:Closed - End of life cycleStart date:May 06, 2021
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:MY CORUSSpent 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.

Also available in: Atom PDF