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 863: FROM ra_customer_trx_lines

859:
860: BEGIN
861: SELECT count(*)
862: INTO p_warehouse_count
863: FROM ra_customer_trx_lines
864: WHERE customer_trx_id = p_customer_trx_id
865: AND line_type = 'LINE'
866: AND warehouse_id IS NULL
867: AND inventory_item_id IS NOT NULL;

Line 877: FROM ra_customer_trx_lines

873:
874: BEGIN
875: SELECT distinct warehouse_id
876: INTO p_warehouse_id
877: FROM ra_customer_trx_lines
878: WHERE customer_trx_id = p_customer_trx_id
879: AND line_type = 'LINE'
880: AND inventory_item_id IS NOT NULL
881: AND rownum = 1;