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.CSP_SHIP_TO_ADDRESS_PVT dependencies on HZ_PARTIES

Line 2224: l_party_id hz_parties.party_id%TYPE := NULL;

2220: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2221: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2222: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2223: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2224: l_party_id hz_parties.party_id%TYPE := NULL;
2225: l_first_name hz_parties.person_first_name%TYPE := NULL;
2226: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2227: l_last_name hz_parties.person_last_name%TYPE := NULL;
2228: l_account_number hz_cust_accounts.account_number%TYPE := NULL;

Line 2225: l_first_name hz_parties.person_first_name%TYPE := NULL;

2221: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2222: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2223: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2224: l_party_id hz_parties.party_id%TYPE := NULL;
2225: l_first_name hz_parties.person_first_name%TYPE := NULL;
2226: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2227: l_last_name hz_parties.person_last_name%TYPE := NULL;
2228: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2229: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;

Line 2226: l_middle_name hz_parties.person_middle_name%TYPE := NULL;

2222: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2223: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2224: l_party_id hz_parties.party_id%TYPE := NULL;
2225: l_first_name hz_parties.person_first_name%TYPE := NULL;
2226: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2227: l_last_name hz_parties.person_last_name%TYPE := NULL;
2228: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2229: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2230: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;

Line 2227: l_last_name hz_parties.person_last_name%TYPE := NULL;

2223: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2224: l_party_id hz_parties.party_id%TYPE := NULL;
2225: l_first_name hz_parties.person_first_name%TYPE := NULL;
2226: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2227: l_last_name hz_parties.person_last_name%TYPE := NULL;
2228: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2229: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2230: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2231: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;

Line 2322: l_party_number hz_parties.party_number%TYPE := NULL;

2318: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2321: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2322: l_party_number hz_parties.party_number%TYPE := NULL;
2323: l_customer_key hz_parties.customer_key%TYPE := NULL;
2324: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2325: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2326: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;

Line 2323: l_customer_key hz_parties.customer_key%TYPE := NULL;

2319: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2320: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2321: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2322: l_party_number hz_parties.party_number%TYPE := NULL;
2323: l_customer_key hz_parties.customer_key%TYPE := NULL;
2324: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2325: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2326: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2327: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;

Line 2325: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;

2321: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2322: l_party_number hz_parties.party_number%TYPE := NULL;
2323: l_customer_key hz_parties.customer_key%TYPE := NULL;
2324: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2325: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2326: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2327: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2328: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2329: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;

Line 2326: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;

2322: l_party_number hz_parties.party_number%TYPE := NULL;
2323: l_customer_key hz_parties.customer_key%TYPE := NULL;
2324: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2325: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2326: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2327: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2328: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2329: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2330: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;

Line 2328: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;

2324: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2325: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2326: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2327: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2328: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2329: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2330: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2331: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2332: l_collector_name VARCHAR2(80) := NULL;

Line 2329: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;

2325: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2326: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2327: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2328: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2329: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2330: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2331: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2332: l_collector_name VARCHAR2(80) := NULL;
2333: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;

Line 2504: hz_parties hp

2500: and jrre.category = 'EMPLOYEE'
2501: UNION ALL
2502: select hp.party_id
2503: from jtf_rs_resource_extns jrre,
2504: hz_parties hp
2505: where hp.party_id = jrre.source_id
2506: and jrre.resource_id = l_resource_id
2507: and jrre.category = 'PARTY';
2508:

Line 2543: select hz_parties_s.nextval from dual;

2539: -- select 'select '||select_id||' select_id, '||select_name||' select_name '|| 'from '||from_table sql_str, where_clause
2540: -- from jtf_objects_vl where object_code = l_resource_type;
2541:
2542: CURSOR l_party_number_csr IS
2543: select hz_parties_s.nextval from dual;
2544:
2545: CURSOR l_customer_number_csr IS
2546: select hz_cust_accounts_s.nextval from dual;
2547: