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.M4U_XML_GENPROCESS_OUT dependencies on CLN_COLL_HIST_HDR

Line 1510: FROM cln_coll_hist_hdr hdr, cln_coll_hist_dtl dtl

1506: l_error_msg VARCHAR2(2000);
1507:
1508: /*CURSOR c_clnidForBatch (p_batchid VARCHAR2,p_subbatch_id VARCHAR2, p_coll_doc_type VARCHAR2) IS
1509: SELECT distinct hdr.collaboration_id
1510: FROM cln_coll_hist_hdr hdr, cln_coll_hist_dtl dtl
1511: WHERE hdr.attribute3 = p_batchid
1512: AND hdr.attribute4 = p_subbatch_id
1513: AND COLLABORATION_DOCUMENT_TYPE = p_coll_doc_type
1514: AND hdr.collaboration_id = dtl.collaboration_id

Line 1519: FROM cln_coll_hist_hdr

1515: AND hdr.xmlg_transaction_type = 'M4U';*/
1516:
1517: CURSOR c_clnidForBatch (p_batchid VARCHAR2,p_subbatch_id VARCHAR2, p_coll_type VARCHAR2) IS
1518: SELECT collaboration_id
1519: FROM cln_coll_hist_hdr
1520: WHERE attribute3 = p_batchid
1521: AND attribute4 = p_subbatch_id
1522: AND collaboration_type = p_coll_type
1523: AND xmlg_transaction_type = 'M4U';