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 630: l_country hz_parties.country%type;

626: p_credit_request_id IN number,
627: p_credit_analyst_id OUT NOCOPY NUMBER ) IS
628:
629:
630: l_country hz_parties.country%type;
631: l_state hz_parties.state%type;
632: l_province hz_parties.province%type;
633: l_sic_code hz_parties.sic_code%type;
634: l_postal_code hz_parties.postal_code%type;

Line 631: l_state hz_parties.state%type;

627: p_credit_analyst_id OUT NOCOPY NUMBER ) IS
628:
629:
630: l_country hz_parties.country%type;
631: l_state hz_parties.state%type;
632: l_province hz_parties.province%type;
633: l_sic_code hz_parties.sic_code%type;
634: l_postal_code hz_parties.postal_code%type;
635: l_party_name hz_parties.party_name%type;

Line 632: l_province hz_parties.province%type;

628:
629:
630: l_country hz_parties.country%type;
631: l_state hz_parties.state%type;
632: l_province hz_parties.province%type;
633: l_sic_code hz_parties.sic_code%type;
634: l_postal_code hz_parties.postal_code%type;
635: l_party_name hz_parties.party_name%type;
636: l_employees_total hz_parties.employees_total%type;

Line 633: l_sic_code hz_parties.sic_code%type;

629:
630: l_country hz_parties.country%type;
631: l_state hz_parties.state%type;
632: l_province hz_parties.province%type;
633: l_sic_code hz_parties.sic_code%type;
634: l_postal_code hz_parties.postal_code%type;
635: l_party_name hz_parties.party_name%type;
636: l_employees_total hz_parties.employees_total%type;
637: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;

Line 634: l_postal_code hz_parties.postal_code%type;

630: l_country hz_parties.country%type;
631: l_state hz_parties.state%type;
632: l_province hz_parties.province%type;
633: l_sic_code hz_parties.sic_code%type;
634: l_postal_code hz_parties.postal_code%type;
635: l_party_name hz_parties.party_name%type;
636: l_employees_total hz_parties.employees_total%type;
637: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
638: l_amount ar_cmgt_credit_requests.limit_amount%type;

Line 635: l_party_name hz_parties.party_name%type;

631: l_state hz_parties.state%type;
632: l_province hz_parties.province%type;
633: l_sic_code hz_parties.sic_code%type;
634: l_postal_code hz_parties.postal_code%type;
635: l_party_name hz_parties.party_name%type;
636: l_employees_total hz_parties.employees_total%type;
637: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
638: l_amount ar_cmgt_credit_requests.limit_amount%type;
639: l_review_type ar_cmgt_credit_requests.review_type%type;

Line 636: l_employees_total hz_parties.employees_total%type;

632: l_province hz_parties.province%type;
633: l_sic_code hz_parties.sic_code%type;
634: l_postal_code hz_parties.postal_code%type;
635: l_party_name hz_parties.party_name%type;
636: l_employees_total hz_parties.employees_total%type;
637: l_credit_classification ar_cmgt_credit_requests.credit_classification%type;
638: l_amount ar_cmgt_credit_requests.limit_amount%type;
639: l_review_type ar_cmgt_credit_requests.review_type%type;
640: l_profile_class_name hz_cust_profile_classes.name%type;

Line 642: l_party_id hz_parties.party_id%type;

638: l_amount ar_cmgt_credit_requests.limit_amount%type;
639: l_review_type ar_cmgt_credit_requests.review_type%type;
640: l_profile_class_name hz_cust_profile_classes.name%type;
641: l_currency ar_cmgt_credit_requests.limit_currency%type;
642: l_party_id hz_parties.party_id%type;
643:
644:
645: BEGIN
646: -- Get All values for parametsrs

Line 658: hz_parties p,

654: l_party_name, l_employees_total, l_credit_classification,
655: l_amount, l_review_type, l_currency,
656: l_profile_class_name, l_postal_code, l_state, l_party_id
657: FROM ar_cmgt_credit_requests c,
658: hz_parties p,
659: hz_cust_profile_classes profclass,
660: hz_customer_profiles prof
661: WHERE c.credit_request_id = p_credit_request_id
662: AND c.party_id = p.party_id

Line 1167: l_party_id hz_parties.party_id%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;
1166: l_requestor_display_name per_people_f.full_name%type;
1167: l_party_id hz_parties.party_id%type;
1168: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1169: l_party_name hz_parties.party_name%type;
1170: l_party_number hz_parties.party_number%type;
1171: l_account_number hz_cust_accounts.account_number%type;

Line 1169: l_party_name hz_parties.party_name%type;

1165: l_requestor_user_name fnd_user.user_name%type;
1166: l_requestor_display_name per_people_f.full_name%type;
1167: l_party_id hz_parties.party_id%type;
1168: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1169: l_party_name hz_parties.party_name%type;
1170: l_party_number hz_parties.party_number%type;
1171: l_account_number hz_cust_accounts.account_number%type;
1172: l_application_date ar_cmgt_credit_requests.application_date%type;
1173: l_source_column1 ar_cmgt_credit_requests.source_column1%type;

Line 1170: l_party_number hz_parties.party_number%type;

1166: l_requestor_display_name per_people_f.full_name%type;
1167: l_party_id hz_parties.party_id%type;
1168: l_cust_account_id hz_cust_accounts.cust_account_id%type;
1169: l_party_name hz_parties.party_name%type;
1170: l_party_number hz_parties.party_number%type;
1171: l_account_number hz_cust_accounts.account_number%type;
1172: l_application_date ar_cmgt_credit_requests.application_date%type;
1173: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
1174: l_source_column2 ar_cmgt_credit_requests.source_column2%type;

Line 1230: hz_parties party

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

Line 1276: hz_parties party

1272: l_amount_requested,
1273: l_credit_request_type,
1274: l_requestor_type
1275: FROM ar_cmgt_credit_requests req,
1276: hz_parties party
1277: WHERE credit_request_id = itemkey
1278: AND req.party_id = party.party_id;
1279:
1280:

Line 3822: l_party_id hz_parties.party_id%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;
3821: l_requestor_display_name per_people_f.full_name%type;
3822: l_party_id hz_parties.party_id%type;
3823: l_cust_account_id hz_cust_accounts.cust_account_id%type;
3824: l_party_name hz_parties.party_name%type;
3825: l_party_number hz_parties.party_number%type;
3826: l_account_number hz_cust_accounts.account_number%type;

Line 3824: l_party_name hz_parties.party_name%type;

3820: l_requestor_user_name fnd_user.user_name%type;
3821: l_requestor_display_name per_people_f.full_name%type;
3822: l_party_id hz_parties.party_id%type;
3823: l_cust_account_id hz_cust_accounts.cust_account_id%type;
3824: l_party_name hz_parties.party_name%type;
3825: l_party_number hz_parties.party_number%type;
3826: l_account_number hz_cust_accounts.account_number%type;
3827: l_application_date ar_cmgt_credit_requests.application_date%type;
3828: l_source_column1 ar_cmgt_credit_requests.source_column1%type;

Line 3825: l_party_number hz_parties.party_number%type;

3821: l_requestor_display_name per_people_f.full_name%type;
3822: l_party_id hz_parties.party_id%type;
3823: l_cust_account_id hz_cust_accounts.cust_account_id%type;
3824: l_party_name hz_parties.party_name%type;
3825: l_party_number hz_parties.party_number%type;
3826: l_account_number hz_cust_accounts.account_number%type;
3827: l_application_date ar_cmgt_credit_requests.application_date%type;
3828: l_source_column1 ar_cmgt_credit_requests.source_column1%type;
3829: l_source_column2 ar_cmgt_credit_requests.source_column2%type;

Line 3878: hz_parties party

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

Line 3922: hz_parties party

3918: l_currency,
3919: l_amount_requested,
3920: l_requestor_type
3921: FROM ar_cmgt_credit_requests req,
3922: hz_parties party
3923: WHERE credit_request_id = itemkey
3924: AND req.party_id = party.party_id;
3925: WHEN OTHERS THEN
3926: wf_core.context ('AR_CMGT_WF_ENGINE','POPULATE_WF_ATTRIBUTES',itemtype,itemkey,