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.AR_CMGT_WF_ENGINE dependencies on AR_CMGT_CHECK_LIST_DTLS

Line 170: FROM ar_cmgt_check_list_dtls

166: cnt NUMBER;
167: l_data_point_id ar_cmgt_data_points_vl.data_point_id%type;
168: CURSOR c_dnb_required_data IS
169: SELECT data_point_id
170: FROM ar_cmgt_check_list_dtls
171: WHERE data_point_id between 10000 and 20000
172: AND check_list_id = p_check_list_id
173: AND required_flag = 'Y';
174:

Line 234: FROM ar_cmgt_check_list_dtls

230: 88 Gurantors
231: ********************************************************/
232: CURSOR c_ref_data_points IS
233: SELECT data_point_id, number_of_references
234: FROM ar_cmgt_check_list_dtls
235: WHERE check_list_id = p_check_list_id
236: AND data_point_id IN (86,87,88)
237: AND required_flag = 'Y';
238:

Line 335: FROM ar_cmgt_check_list_dtls a, ar_cmgt_cf_dtls b,

331: END IF;
332: l_check_list_id := p_check_list_id;
333: BEGIN
334: SELECT 1 into l_cnt
335: FROM ar_cmgt_check_list_dtls a, ar_cmgt_cf_dtls b,
336: ar_cmgt_data_points_vl dp
337: WHERE a.check_list_id = l_check_list_id
338: AND b.case_folder_id = p_case_folder_id
339: AND a.data_point_id = b.data_point_id