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_PND

Line 1561: --(in 1,2) and TRANS_ID not in (SELECT TRANS_ID from ic_tran_pnd where doc_id=pdoc_id and doc_type='OPSO' and delete_mark=1)

1557: -- GL_POSTED_IND GL posted indicator. 0=Not posted to GL, 1=Posted to GL.
1558: -- DELETE_MARK Standard: 0=Active record (default); 1=Marked for (logical) deletion.
1559: -- TRANS_ID (PK) Unique key for the transaction.
1560:
1561: --(in 1,2) and TRANS_ID not in (SELECT TRANS_ID from ic_tran_pnd where doc_id=pdoc_id and doc_type='OPSO' and delete_mark=1)
1562:
1563: cursor c2 (pdoc_id ic_tran_pnd.doc_id%type)
1564: IS
1565: select count(*) COUNT_GL_POSTED_IND, 0 COUNT_COMPLETED_IND

Line 1563: cursor c2 (pdoc_id ic_tran_pnd.doc_id%type)

1559: -- TRANS_ID (PK) Unique key for the transaction.
1560:
1561: --(in 1,2) and TRANS_ID not in (SELECT TRANS_ID from ic_tran_pnd where doc_id=pdoc_id and doc_type='OPSO' and delete_mark=1)
1562:
1563: cursor c2 (pdoc_id ic_tran_pnd.doc_id%type)
1564: IS
1565: select count(*) COUNT_GL_POSTED_IND, 0 COUNT_COMPLETED_IND
1566: from ic_tran_pnd
1567: where doc_id =pdoc_id

Line 1566: from ic_tran_pnd

1562:
1563: cursor c2 (pdoc_id ic_tran_pnd.doc_id%type)
1564: IS
1565: select count(*) COUNT_GL_POSTED_IND, 0 COUNT_COMPLETED_IND
1566: from ic_tran_pnd
1567: where doc_id =pdoc_id
1568: and doc_type = 'OPSO'
1569: and delete_mark=0
1570: and gl_posted_ind <>1

Line 1573: from ic_tran_pnd

1569: and delete_mark=0
1570: and gl_posted_ind <>1
1571: UNION ALL
1572: select 0,count(*)
1573: from ic_tran_pnd
1574: where doc_id = pdoc_id
1575: and doc_type = 'OPSO'
1576: and delete_mark=0
1577: and completed_ind =0;