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.OCM_GET_EXTRL_DECSN_PUB dependencies on AR_CMGT_SCORE_DTLS

Line 25: l_data_point_id ar_cmgt_score_dtls.DATA_POINT_ID%type;

21: p_score IN NUMBER
22: ) IS
23: l_case_folder_type ar_cmgt_case_folders.type%type;
24: l_case_folder_status ar_cmgt_case_folders.status%type;
25: l_data_point_id ar_cmgt_score_dtls.DATA_POINT_ID%type;
26: l_party_id ar_cmgt_case_folders.party_id%type;
27: l_cust_account_id ar_cmgt_case_folders.cust_account_id%type;
28: l_site_use_id ar_cmgt_case_folders.site_use_id%type;
29: l_score_model_id ar_cmgt_case_folders.score_model_id%type;

Line 82: from ar_cmgt_score_dtls sc, ar_cmgt_data_points_vl dp

78: IF p_score_model_id IS NOT NULL and (p_score_model_id = l_score_model_id) THEN
79: BEGIN
80: select sc.DATA_POINT_ID, dp.data_point_code
81: into l_data_point_id, l_data_point_code
82: from ar_cmgt_score_dtls sc, ar_cmgt_data_points_vl dp
83: where sc.SCORE_MODEL_ID = p_score_model_id
84: and sc.data_point_id = dp.data_point_id
85: and dp.data_point_code = 'OCM_EXTERNAL_SCORE';
86: