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 507: l_source_table_name ar_cmgt_dnb_elements_vl.source_table_name%type;

503: p_case_folder_id IN NUMBER,
504: p_data_point_id IN NUMBER,
505: p_data_point_value OUT NOCOPY VARCHAR2) IS
506:
507: l_source_table_name ar_cmgt_dnb_elements_vl.source_table_name%type;
508: l_source_column_name ar_cmgt_dnb_elements_vl.source_column_name%type;
509: l_source_key ar_cmgt_cf_dnb_dtls.source_key%type;
510: l_source_key_type ar_cmgt_cf_dnb_dtls.source_key_type%type;
511: l_source_key_column_name ar_cmgt_cf_dnb_dtls.source_key_column_name%type;

Line 508: l_source_column_name ar_cmgt_dnb_elements_vl.source_column_name%type;

504: p_data_point_id IN NUMBER,
505: p_data_point_value OUT NOCOPY VARCHAR2) IS
506:
507: l_source_table_name ar_cmgt_dnb_elements_vl.source_table_name%type;
508: l_source_column_name ar_cmgt_dnb_elements_vl.source_column_name%type;
509: l_source_key ar_cmgt_cf_dnb_dtls.source_key%type;
510: l_source_key_type ar_cmgt_cf_dnb_dtls.source_key_type%type;
511: l_source_key_column_name ar_cmgt_cf_dnb_dtls.source_key_column_name%type;
512: l_source_key_column_type ar_cmgt_cf_dnb_dtls.source_key_column_type_name%type;

Line 521: FROM ar_cmgt_dnb_elements_vl

517: queryStr VARCHAR2(2000);
518: BEGIN
519: SELECT source_table_name, source_column_name
520: INTO l_source_table_name, l_source_column_name
521: FROM ar_cmgt_dnb_elements_vl
522: WHERE data_element_id = p_data_point_id;
523:
524: SELECT cfd.source_key, cfd.source_key_type, cfd.source_key_column_name,
525: cfd.source_key_column_type_name