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_NTFYINVC_PKG dependencies on CLN_3C3_INVOICE_V

Line 326: FROM CLN_3C3_INVOICE_V

322: BEGIN
323:
324: SELECT customer_trx_id, org_id, trx_number,trx_date
325: INTO l_customer_trx_id, l_organization_id, l_trx_number,l_inv_date
326: FROM CLN_3C3_INVOICE_V
327: WHERE document_transfer_id = l_doc_transfer_id AND ROWNUM < 2;
328:
329: EXCEPTION
330: WHEN OTHERS THEN

Line 333: cln_debug_pub.Add('Exception - Querying the CLN_3C3_INVOICE_V failed', 1);

329: EXCEPTION
330: WHEN OTHERS THEN
331:
332: IF (l_debug_level <= 1) THEN
333: cln_debug_pub.Add('Exception - Querying the CLN_3C3_INVOICE_V failed', 1);
334: END IF;
335: END;
336:
337: -- generate Document Creation Date

Line 603: FROM CLN_3C3_INVOICE_V

599: BEGIN
600:
601: SELECT trx_date
602: INTO l_trx_date
603: FROM CLN_3C3_INVOICE_V
604: WHERE document_transfer_id = p_doc_trnsfr_id and rownum < 2;
605:
606: EXCEPTION
607: WHEN OTHERS THEN