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.IGI_DUNN_POST_UPG_PKG dependencies on AR_DUNNING_LETTER_SET_LINES

Line 20: FROM ar_dunning_letter_set_lines adlsl,

16: SELECT adls.dunning_letter_set_id,
17: adlsl.dunning_line_num,
18: adlsl.range_of_days_from,
19: adlsl.range_of_days_to
20: FROM ar_dunning_letter_set_lines adlsl,
21: igi_dun_letter_sets idls,
22: ar_dunning_letter_sets adls
23: WHERE adls.dunning_letter_set_id = p_dls_id
24: AND adls.dunning_letter_set_id = idls.dunning_letter_set_id

Line 72: FROM ar_dunning_letter_set_lines adlsl,

68: idlsl.currency_code ccy_code,
69: idlsl.letter_charge_amount,
70: idlsl.invoice_charge_amount,
71: (SELECT charge_per_invoice_flag FROM igi_dun_letter_sets WHERE dunning_letter_set_id = p_dls_id) charge_type
72: FROM ar_dunning_letter_set_lines adlsl,
73: igi_dun_letter_set_lines idlsl,
74: ar_dunning_letter_sets adls
75: WHERE adlsl.dunning_letter_set_id = idlsl.dunning_letter_set_id
76: AND adlsl.dunning_line_num = idlsl.dunning_line_num

Line 128: FROM ar_dunning_letter_set_lines adlsl,

124: idclsl.customer_profile_id,
125: idclsl.customer_profile_class_id,
126: idclsl.site_use_id,
127: (SELECT charge_per_invoice_flag FROM igi_dun_letter_sets WHERE dunning_letter_set_id = p_dls_id) charge_type
128: FROM ar_dunning_letter_set_lines adlsl,
129: igi_dun_cust_letter_set_lines idclsl,
130: ar_dunning_letter_sets adls
131: WHERE adlsl.dunning_letter_set_id = adls.dunning_letter_set_id
132: AND adlsl.dunning_letter_set_id = idclsl.dunning_letter_set_id