eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMA_PURGE_ENGINE dependencies on IC_TRAN_CMP

Line 1715: -- ic_tran_cmp will never be set to 1. Ignoring the gl_posted_ind validation for these types GRDI GRDR STSI STSR

1711: AND IJ1.creation_date >= P_MINCDATE
1712: AND IJ1.creation_date <= P_MAXCDATE;
1713:
1714: -- Status and grade Journal type GMI transactions are not posted to the subledger and gl_posted_ind in
1715: -- ic_tran_cmp will never be set to 1. Ignoring the gl_posted_ind validation for these types GRDI GRDR STSI STSR
1716:
1717: cursor c2 (pdoc_id ic_tran_cmp.doc_id%type) is
1718: select count(*)
1719: from ic_tran_cmp

Line 1717: cursor c2 (pdoc_id ic_tran_cmp.doc_id%type) is

1713:
1714: -- Status and grade Journal type GMI transactions are not posted to the subledger and gl_posted_ind in
1715: -- ic_tran_cmp will never be set to 1. Ignoring the gl_posted_ind validation for these types GRDI GRDR STSI STSR
1716:
1717: cursor c2 (pdoc_id ic_tran_cmp.doc_id%type) is
1718: select count(*)
1719: from ic_tran_cmp
1720: where doc_id = pdoc_id
1721: and doc_type in ('CREI','CRER','ADJI','ADJR','TRNI','TRNR')

Line 1719: from ic_tran_cmp

1715: -- ic_tran_cmp will never be set to 1. Ignoring the gl_posted_ind validation for these types GRDI GRDR STSI STSR
1716:
1717: cursor c2 (pdoc_id ic_tran_cmp.doc_id%type) is
1718: select count(*)
1719: from ic_tran_cmp
1720: where doc_id = pdoc_id
1721: and doc_type in ('CREI','CRER','ADJI','ADJR','TRNI','TRNR')
1722: --excludes ('GRDI','GRDR','STSI','STSR') types per bug 2441842
1723: -- Bug #2602036 (JKB) Removed 'upper' and 'not in' above.