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_SCORING_ENGINE dependencies on AR_CMGT_DNB_ELEMENTS_VL

Line 387: l_source_table_name ar_cmgt_dnb_elements_vl.source_table_name%type;

383: p_case_folder_id IN NUMBER,
384: p_data_point_id IN NUMBER,
385: p_data_point_value OUT NOCOPY VARCHAR2) IS
386:
387: l_source_table_name ar_cmgt_dnb_elements_vl.source_table_name%type;
388: l_source_column_name ar_cmgt_dnb_elements_vl.source_column_name%type;
389: l_source_key ar_cmgt_cf_dnb_dtls.source_key%type;
390: l_source_key_type ar_cmgt_cf_dnb_dtls.source_key_type%type;
391: l_source_key_column_name ar_cmgt_cf_dnb_dtls.source_key_column_name%type;

Line 388: l_source_column_name ar_cmgt_dnb_elements_vl.source_column_name%type;

384: p_data_point_id IN NUMBER,
385: p_data_point_value OUT NOCOPY VARCHAR2) IS
386:
387: l_source_table_name ar_cmgt_dnb_elements_vl.source_table_name%type;
388: l_source_column_name ar_cmgt_dnb_elements_vl.source_column_name%type;
389: l_source_key ar_cmgt_cf_dnb_dtls.source_key%type;
390: l_source_key_type ar_cmgt_cf_dnb_dtls.source_key_type%type;
391: l_source_key_column_name ar_cmgt_cf_dnb_dtls.source_key_column_name%type;
392: l_source_key_column_type ar_cmgt_cf_dnb_dtls.source_key_column_type_name%type;

Line 401: FROM ar_cmgt_dnb_elements_vl

397: queryStr VARCHAR2(2000);
398: BEGIN
399: SELECT source_table_name, source_column_name
400: INTO l_source_table_name, l_source_column_name
401: FROM ar_cmgt_dnb_elements_vl
402: WHERE data_element_id = p_data_point_id;
403:
404: SELECT cfd.source_key, cfd.source_key_type, cfd.source_key_column_name,
405: cfd.source_key_column_type_name