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

Line 355: FROM CLN_COLL_HIST_DTL where collaboration_dtl_id =

351: -- Get the txn type, txn subtype, xmlg doc id, xmlg msg id
352: -- of the last outbound message for this collaboration
353: SELECT xmlg_transaction_type, xmlg_transaction_subtype, xmlg_document_id, xmlg_msg_id
354: INTO l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_document_id, l_msg_id
355: FROM CLN_COLL_HIST_DTL where collaboration_dtl_id =
356: (SELECT MAX(collaboration_dtl_id) FROM CLN_COLL_HIST_DTL
357: WHERE document_direction = 'OUT' AND collaboration_id = l_collaboration_id);
358:
359: IF (l_Debug_Level <= 1) THEN

Line 356: (SELECT MAX(collaboration_dtl_id) FROM CLN_COLL_HIST_DTL

352: -- of the last outbound message for this collaboration
353: SELECT xmlg_transaction_type, xmlg_transaction_subtype, xmlg_document_id, xmlg_msg_id
354: INTO l_xmlg_transaction_type, l_xmlg_transaction_subtype, l_xmlg_document_id, l_msg_id
355: FROM CLN_COLL_HIST_DTL where collaboration_dtl_id =
356: (SELECT MAX(collaboration_dtl_id) FROM CLN_COLL_HIST_DTL
357: WHERE document_direction = 'OUT' AND collaboration_id = l_collaboration_id);
358:
359: IF (l_Debug_Level <= 1) THEN
360: ecx_cln_debug_pub.Add('l_xmlg_transaction_type:' || l_xmlg_transaction_type, 1);