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.JL_ZZ_AR_LIBRARY_1_PKG dependencies on RA_CUSTOMER_TRX_LINES

Line 531: FROM ra_customer_trx_lines

527: SELECT TO_NUMBER (global_attribute11),
528: TO_NUMBER (global_attribute12)
529: INTO base_amt,
530: base_rate
531: FROM ra_customer_trx_lines
532: WHERE customer_trx_line_id = cust_trx_id
533: AND rownum = row_number;
534: EXCEPTION
535: WHEN OTHERS THEN

Line 849: FROM ra_customer_trx_lines

845:
846: BEGIN
847: SELECT count(*)
848: INTO p_warehouse_count
849: FROM ra_customer_trx_lines
850: WHERE customer_trx_id = p_customer_trx_id
851: AND line_type = 'LINE'
852: AND warehouse_id IS NULL
853: AND inventory_item_id IS NOT NULL;

Line 863: FROM ra_customer_trx_lines

859:
860: BEGIN
861: SELECT distinct warehouse_id
862: INTO p_warehouse_id
863: FROM ra_customer_trx_lines
864: WHERE customer_trx_id = p_customer_trx_id
865: AND line_type = 'LINE'
866: AND inventory_item_id IS NOT NULL
867: AND rownum = 1;