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_LOOKUPS

Line 1160: l_classification_meaning ar_lookups.meaning%type;

1156: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
1157: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
1158: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
1159: l_source_name ar_cmgt_credit_requests.source_name%type;
1160: l_classification_meaning ar_lookups.meaning%type;
1161: l_review_type_meaning ar_lookups.meaning%type;
1162: l_application_number ar_cmgt_credit_requests.application_number%type;
1163: l_score_model_already_set VARCHAR2(1) := 'F';
1164: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;

Line 1161: l_review_type_meaning ar_lookups.meaning%type;

1157: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
1158: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
1159: l_source_name ar_cmgt_credit_requests.source_name%type;
1160: l_classification_meaning ar_lookups.meaning%type;
1161: l_review_type_meaning ar_lookups.meaning%type;
1162: l_application_number ar_cmgt_credit_requests.application_number%type;
1163: l_score_model_already_set VARCHAR2(1) := 'F';
1164: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
1165: l_requestor_user_name fnd_user.user_name%type;

Line 1228: ar_lookups lkp1,

1224: l_notes,
1225: l_credit_request_type,
1226: l_requestor_type
1227: FROM ar_cmgt_credit_requests req,
1228: ar_lookups lkp1,
1229: ar_lookups lkp2,
1230: hz_parties party
1231: WHERE req.credit_request_id = itemkey
1232: AND req.party_id = party.party_id

Line 1229: ar_lookups lkp2,

1225: l_credit_request_type,
1226: l_requestor_type
1227: FROM ar_cmgt_credit_requests req,
1228: ar_lookups lkp1,
1229: ar_lookups lkp2,
1230: hz_parties party
1231: WHERE req.credit_request_id = itemkey
1232: AND req.party_id = party.party_id
1233: AND lkp1.lookup_type = 'AR_CMGT_CREDIT_CLASSIFICATION'

Line 3815: l_classification_meaning ar_lookups.meaning%type;

3811: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
3812: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
3813: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
3814: l_source_name ar_cmgt_credit_requests.source_name%type;
3815: l_classification_meaning ar_lookups.meaning%type;
3816: l_review_type_meaning ar_lookups.meaning%type;
3817: l_application_number ar_cmgt_credit_requests.application_number%type;
3818: l_score_model_already_set VARCHAR2(1) := 'F';
3819: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;

Line 3816: l_review_type_meaning ar_lookups.meaning%type;

3812: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
3813: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
3814: l_source_name ar_cmgt_credit_requests.source_name%type;
3815: l_classification_meaning ar_lookups.meaning%type;
3816: l_review_type_meaning ar_lookups.meaning%type;
3817: l_application_number ar_cmgt_credit_requests.application_number%type;
3818: l_score_model_already_set VARCHAR2(1) := 'F';
3819: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
3820: l_requestor_user_name fnd_user.user_name%type;

Line 3876: ar_lookups lkp1,

3872: l_party_number,
3873: l_notes,
3874: l_requestor_type
3875: FROM ar_cmgt_credit_requests req,
3876: ar_lookups lkp1,
3877: ar_lookups lkp2,
3878: hz_parties party
3879: WHERE req.credit_request_id = itemkey
3880: AND req.party_id = party.party_id

Line 3877: ar_lookups lkp2,

3873: l_notes,
3874: l_requestor_type
3875: FROM ar_cmgt_credit_requests req,
3876: ar_lookups lkp1,
3877: ar_lookups lkp2,
3878: hz_parties party
3879: WHERE req.credit_request_id = itemkey
3880: AND req.party_id = party.party_id
3881: AND lkp1.lookup_type = 'AR_CMGT_CREDIT_CLASSIFICATION'