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 1404: l_classification_meaning ar_lookups.meaning%type;

1400: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
1401: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
1402: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
1403: l_source_name ar_cmgt_credit_requests.source_name%type;
1404: l_classification_meaning ar_lookups.meaning%type;
1405: l_review_type_meaning ar_lookups.meaning%type;
1406: l_application_number ar_cmgt_credit_requests.application_number%type;
1407: l_score_model_already_set VARCHAR2(1) := 'F';
1408: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;

Line 1405: l_review_type_meaning ar_lookups.meaning%type;

1401: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
1402: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
1403: l_source_name ar_cmgt_credit_requests.source_name%type;
1404: l_classification_meaning ar_lookups.meaning%type;
1405: l_review_type_meaning ar_lookups.meaning%type;
1406: l_application_number ar_cmgt_credit_requests.application_number%type;
1407: l_score_model_already_set VARCHAR2(1) := 'F';
1408: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
1409: l_requestor_user_name fnd_user.user_name%type;

Line 1472: ar_lookups lkp1,

1468: l_notes,
1469: l_credit_request_type,
1470: l_requestor_type
1471: FROM ar_cmgt_credit_requests req,
1472: ar_lookups lkp1,
1473: ar_lookups lkp2,
1474: hz_parties party
1475: WHERE req.credit_request_id = itemkey
1476: AND req.party_id = party.party_id

Line 1473: ar_lookups lkp2,

1469: l_credit_request_type,
1470: l_requestor_type
1471: FROM ar_cmgt_credit_requests req,
1472: ar_lookups lkp1,
1473: ar_lookups lkp2,
1474: hz_parties party
1475: WHERE req.credit_request_id = itemkey
1476: AND req.party_id = party.party_id
1477: AND lkp1.lookup_type = 'AR_CMGT_CREDIT_CLASSIFICATION'

Line 4323: l_classification_meaning ar_lookups.meaning%type;

4319: l_currency ar_cmgt_credit_requests.limit_currency%TYPE;
4320: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
4321: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
4322: l_source_name ar_cmgt_credit_requests.source_name%type;
4323: l_classification_meaning ar_lookups.meaning%type;
4324: l_review_type_meaning ar_lookups.meaning%type;
4325: l_application_number ar_cmgt_credit_requests.application_number%type;
4326: l_score_model_already_set VARCHAR2(1) := 'F';
4327: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;

Line 4324: l_review_type_meaning ar_lookups.meaning%type;

4320: l_amount_requested ar_cmgt_credit_requests.limit_amount%TYPE;
4321: l_case_folder_number ar_cmgt_case_folders.case_folder_number%type;
4322: l_source_name ar_cmgt_credit_requests.source_name%type;
4323: l_classification_meaning ar_lookups.meaning%type;
4324: l_review_type_meaning ar_lookups.meaning%type;
4325: l_application_number ar_cmgt_credit_requests.application_number%type;
4326: l_score_model_already_set VARCHAR2(1) := 'F';
4327: l_requestor_id ar_cmgt_credit_requests.requestor_id%type;
4328: l_requestor_user_name fnd_user.user_name%type;

Line 4385: ar_lookups lkp1,

4381: l_party_number,
4382: l_notes,
4383: l_requestor_type
4384: FROM ar_cmgt_credit_requests req,
4385: ar_lookups lkp1,
4386: ar_lookups lkp2,
4387: hz_parties party
4388: WHERE req.credit_request_id = itemkey
4389: AND req.party_id = party.party_id

Line 4386: ar_lookups lkp2,

4382: l_notes,
4383: l_requestor_type
4384: FROM ar_cmgt_credit_requests req,
4385: ar_lookups lkp1,
4386: ar_lookups lkp2,
4387: hz_parties party
4388: WHERE req.credit_request_id = itemkey
4389: AND req.party_id = party.party_id
4390: AND lkp1.lookup_type = 'AR_CMGT_CREDIT_CLASSIFICATION'