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 HZ_PARTIES

Line 669: l_country hz_parties.country%type;

665: p_credit_request_id IN number,
666: p_credit_analyst_id OUT NOCOPY NUMBER ) IS
667:
668:
669: l_country hz_parties.country%type;
670: l_state hz_parties.state%type;
671: l_province hz_parties.province%type;
672: l_sic_code hz_parties.sic_code%type;
673: l_postal_code hz_parties.postal_code%type;

Line 670: l_state hz_parties.state%type;

666: p_credit_analyst_id OUT NOCOPY NUMBER ) IS
667:
668:
669: l_country hz_parties.country%type;
670: l_state hz_parties.state%type;
671: l_province hz_parties.province%type;
672: l_sic_code hz_parties.sic_code%type;
673: l_postal_code hz_parties.postal_code%type;
674: l_party_name hz_parties.party_name%type;

Line 671: l_province hz_parties.province%type;

667:
668:
669: l_country hz_parties.country%type;
670: l_state hz_parties.state%type;
671: l_province hz_parties.province%type;
672: l_sic_code hz_parties.sic_code%type;
673: l_postal_code hz_parties.postal_code%type;
674: l_party_name hz_parties.party_name%type;
675: l_employees_total hz_parties.employees_total%type;

Line 672: l_sic_code hz_parties.sic_code%type;

668:
669: l_country hz_parties.country%type;
670: l_state hz_parties.state%type;
671: l_province hz_parties.province%type;
672: l_sic_code hz_parties.sic_code%type;
673: l_postal_code hz_parties.postal_code%type;
674: l_party_name hz_parties.party_name%type;
675: l_employees_total hz_parties.employees_total%type;
676: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;

Line 673: l_postal_code hz_parties.postal_code%type;

669: l_country hz_parties.country%type;
670: l_state hz_parties.state%type;
671: l_province hz_parties.province%type;
672: l_sic_code hz_parties.sic_code%type;
673: l_postal_code hz_parties.postal_code%type;
674: l_party_name hz_parties.party_name%type;
675: l_employees_total hz_parties.employees_total%type;
676: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
677: l_amount ar_cmgt_credit_requests.limit_amount%type;

Line 674: l_party_name hz_parties.party_name%type;

670: l_state hz_parties.state%type;
671: l_province hz_parties.province%type;
672: l_sic_code hz_parties.sic_code%type;
673: l_postal_code hz_parties.postal_code%type;
674: l_party_name hz_parties.party_name%type;
675: l_employees_total hz_parties.employees_total%type;
676: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
677: l_amount ar_cmgt_credit_requests.limit_amount%type;
678: l_review_type ar_cmgt_credit_requests.review_type%type;

Line 675: l_employees_total hz_parties.employees_total%type;

671: l_province hz_parties.province%type;
672: l_sic_code hz_parties.sic_code%type;
673: l_postal_code hz_parties.postal_code%type;
674: l_party_name hz_parties.party_name%type;
675: l_employees_total hz_parties.employees_total%type;
676: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
677: l_amount ar_cmgt_credit_requests.limit_amount%type;
678: l_review_type ar_cmgt_credit_requests.review_type%type;
679: l_profile_class_name hz_cust_profile_classes.name%type;

Line 681: l_party_id hz_parties.party_id%type;

677: l_amount ar_cmgt_credit_requests.limit_amount%type;
678: l_review_type ar_cmgt_credit_requests.review_type%type;
679: l_profile_class_name hz_cust_profile_classes.name%type;
680: l_currency ar_cmgt_credit_requests.limit_currency%type;
681: l_party_id hz_parties.party_id%type;
682:
683: /* 7132845 */
684: l_parent_request_id NUMBER;
685: l_parent_analyst_id NUMBER;

Line 775: hz_parties p,

771: l_party_name, l_employees_total, l_credit_classification,
772: l_amount, l_review_type, l_currency,
773: l_profile_class_name, l_postal_code, l_state, l_party_id
774: FROM ar_cmgt_credit_requests c,
775: hz_parties p,
776: hz_cust_profile_classes profclass,
777: hz_customer_profiles prof
778: WHERE c.credit_request_id = p_credit_request_id
779: AND c.party_id = p.party_id

Line 1411: l_party_id hz_parties.party_id%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;
1410: l_requestor_display_name per_people_f.full_name%type;
1411: l_party_id hz_parties.party_id%type;
1412: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1413: l_party_name hz_parties.party_name%type;
1414: l_party_number hz_parties.party_number%type;
1415: l_account_number hz_cust_accounts.account_number%type;

Line 1413: l_party_name hz_parties.party_name%type;

1409: l_requestor_user_name fnd_user.user_name%type;
1410: l_requestor_display_name per_people_f.full_name%type;
1411: l_party_id hz_parties.party_id%type;
1412: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1413: l_party_name hz_parties.party_name%type;
1414: l_party_number hz_parties.party_number%type;
1415: l_account_number hz_cust_accounts.account_number%type;
1416: l_application_date ar_cmgt_credit_requests.application_date%type;
1417: l_source_column1 ar_cmgt_credit_requests.source_column1%type;

Line 1414: l_party_number hz_parties.party_number%type;

1410: l_requestor_display_name per_people_f.full_name%type;
1411: l_party_id hz_parties.party_id%type;
1412: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1413: l_party_name hz_parties.party_name%type;
1414: l_party_number hz_parties.party_number%type;
1415: l_account_number hz_cust_accounts.account_number%type;
1416: l_application_date ar_cmgt_credit_requests.application_date%type;
1417: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
1418: l_source_column2 ar_cmgt_credit_requests.source_column2%type;

Line 1474: hz_parties party

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'
1478: AND lkp1.lookup_code = req.credit_classification

Line 1520: hz_parties party

1516: l_amount_requested,
1517: l_credit_request_type,
1518: l_requestor_type
1519: FROM ar_cmgt_credit_requests req,
1520: hz_parties party
1521: WHERE credit_request_id = itemkey
1522: AND req.party_id = party.party_id;
1523:
1524:

Line 4330: l_party_id hz_parties.party_id%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;
4329: l_requestor_display_name per_people_f.full_name%type;
4330: l_party_id hz_parties.party_id%type;
4331: l_cust_account_id hz_cust_accounts.cust_account_id%type;
4332: l_party_name hz_parties.party_name%type;
4333: l_party_number hz_parties.party_number%type;
4334: l_account_number hz_cust_accounts.account_number%type;

Line 4332: l_party_name hz_parties.party_name%type;

4328: l_requestor_user_name fnd_user.user_name%type;
4329: l_requestor_display_name per_people_f.full_name%type;
4330: l_party_id hz_parties.party_id%type;
4331: l_cust_account_id hz_cust_accounts.cust_account_id%type;
4332: l_party_name hz_parties.party_name%type;
4333: l_party_number hz_parties.party_number%type;
4334: l_account_number hz_cust_accounts.account_number%type;
4335: l_application_date ar_cmgt_credit_requests.application_date%type;
4336: l_source_column1 ar_cmgt_credit_requests.source_column1%type;

Line 4333: l_party_number hz_parties.party_number%type;

4329: l_requestor_display_name per_people_f.full_name%type;
4330: l_party_id hz_parties.party_id%type;
4331: l_cust_account_id hz_cust_accounts.cust_account_id%type;
4332: l_party_name hz_parties.party_name%type;
4333: l_party_number hz_parties.party_number%type;
4334: l_account_number hz_cust_accounts.account_number%type;
4335: l_application_date ar_cmgt_credit_requests.application_date%type;
4336: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
4337: l_source_column2 ar_cmgt_credit_requests.source_column2%type;

Line 4387: hz_parties party

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'
4391: AND lkp1.lookup_code = req.credit_classification

Line 4431: hz_parties party

4427: l_currency,
4428: l_amount_requested,
4429: l_requestor_type
4430: FROM ar_cmgt_credit_requests req,
4431: hz_parties party
4432: WHERE credit_request_id = itemkey
4433: AND req.party_id = party.party_id;
4434: WHEN OTHERS THEN
4435: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTES',itemtype,itemkey,