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_CF_DNB_DTLS

Line 509: l_source_key ar_cmgt_cf_dnb_dtls.source_key%type;

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;
513:

Line 510: l_source_key_type ar_cmgt_cf_dnb_dtls.source_key_type%type;

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;
513:
514: TYPE cur_type IS REF CURSOR;

Line 511: l_source_key_column_name ar_cmgt_cf_dnb_dtls.source_key_column_name%type;

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;
513:
514: TYPE cur_type IS REF CURSOR;
515: c cur_type;

Line 512: l_source_key_column_type ar_cmgt_cf_dnb_dtls.source_key_column_type_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;
513:
514: TYPE cur_type IS REF CURSOR;
515: c cur_type;
516:

Line 528: FROM ar_cmgt_cf_dnb_dtls cfd

524: SELECT cfd.source_key, cfd.source_key_type, cfd.source_key_column_name,
525: cfd.source_key_column_type_name
526: INTO l_source_key, l_source_key_type, l_source_key_column_name,
527: l_source_key_column_type
528: FROM ar_cmgt_cf_dnb_dtls cfd
529: WHERE cfd.case_folder_id = p_case_folder_id
530: AND cfd.source_table_name = l_source_table_name;
531:
532: IF l_source_key_type IS NULL