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 191: FROM ar_cmgt_check_list_dtls

187: cnt NUMBER;
188: l_data_point_id ar_cmgt_data_points_vl.data_point_id%type;
189: CURSOR c_dnb_required_data IS
190: SELECT data_point_id
191: FROM ar_cmgt_check_list_dtls
192: WHERE data_point_id between 10000 and 20000
193: AND check_list_id = p_check_list_id
194: AND required_flag = 'Y';
195:

Line 255: FROM ar_cmgt_check_list_dtls

251: 88 Gurantors
252: ********************************************************/
253: CURSOR c_ref_data_points IS
254: SELECT data_point_id, number_of_references
255: FROM ar_cmgt_check_list_dtls
256: WHERE check_list_id = p_check_list_id
257: AND data_point_id IN (86,87,88)
258: AND required_flag = 'Y';
259:

Line 356: FROM ar_cmgt_check_list_dtls a, ar_cmgt_cf_dtls b,

352: END IF;
353: l_check_list_id := p_check_list_id;
354: BEGIN
355: SELECT 1 into l_cnt
356: FROM ar_cmgt_check_list_dtls a, ar_cmgt_cf_dtls b,
357: ar_cmgt_data_points_vl dp
358: WHERE a.check_list_id = l_check_list_id
359: AND b.case_folder_id = p_case_folder_id
360: AND a.data_point_id = b.data_point_id