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.XNB_UTIL_PVT dependencies on CLN_COLL_HIST_DTL

Line 123: cln_coll_hist_dtl clndtl

119:
120: select COUNT(clndtl.collaboration_dtl_id)
121: into l_num
122: from cln_coll_hist_hdr clnhdr,
123: cln_coll_hist_dtl clndtl
124: where
125: clnhdr.application_id = 881
126: and clnhdr.collaboration_type = p_collab_type
127: and clnhdr.document_no = p_doc_no

Line 259: cln_coll_hist_dtl clndtl

255: --Check the number of Successful ConfirmBODs sent by the given billing app.
256: SELECT COUNT(clndtl.collaboration_dtl_id)
257: INTO l_num
258: FROM cln_coll_hist_hdr clnhdr,
259: cln_coll_hist_dtl clndtl
260: WHERE
261: clnhdr.application_id = 881
262: AND clnhdr.collaboration_type = p_collab_type
263: AND clnhdr.document_no = p_doc_no