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 2730: l_party_id hz_parties.party_id%TYPE := NULL;

2726: l_inv_location_id hr_locations_all.location_id%TYPE := NULL;
2727: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2728: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2729: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2730: l_party_id hz_parties.party_id%TYPE := NULL;
2731: l_first_name hz_parties.person_first_name%TYPE := NULL;
2732: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2733: l_last_name hz_parties.person_last_name%TYPE := NULL;
2734: l_account_number hz_cust_accounts.account_number%TYPE := NULL;

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

2727: l_resource_id jtf_task_assignments.resource_id%TYPE := NULL;
2728: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2729: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2730: l_party_id hz_parties.party_id%TYPE := NULL;
2731: l_first_name hz_parties.person_first_name%TYPE := NULL;
2732: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2733: l_last_name hz_parties.person_last_name%TYPE := NULL;
2734: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2735: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;

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

2728: l_resource_type jtf_task_assignments.resource_type_code%TYPE := NULL;
2729: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2730: l_party_id hz_parties.party_id%TYPE := NULL;
2731: l_first_name hz_parties.person_first_name%TYPE := NULL;
2732: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2733: l_last_name hz_parties.person_last_name%TYPE := NULL;
2734: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2735: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2736: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;

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

2729: l_resource_name jtf_rs_resource_extns_vl.resource_name%TYPE := NULL;
2730: l_party_id hz_parties.party_id%TYPE := NULL;
2731: l_first_name hz_parties.person_first_name%TYPE := NULL;
2732: l_middle_name hz_parties.person_middle_name%TYPE := NULL;
2733: l_last_name hz_parties.person_last_name%TYPE := NULL;
2734: l_account_number hz_cust_accounts.account_number%TYPE := NULL;
2735: l_customer_number hz_cust_accounts.account_number%TYPE := NULL;
2736: l_Attribute_Category hz_cust_accounts.attribute_category%TYPE := NULL;
2737: l_Attribute1 hz_cust_accounts.attribute1%TYPE := NULL;

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

2824: l_SHIP_SETS_INCLUDE_LINES_FLAG hz_cust_accounts.SHIP_SETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2825: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2826: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2827: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2828: l_party_number hz_parties.party_number%TYPE := NULL;
2829: l_customer_key hz_parties.customer_key%TYPE := NULL;
2830: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2831: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2832: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;

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

2825: l_ARRIVALSETS_INCL_LINES_FLAG hz_cust_accounts.ARRIVALSETS_INCLUDE_LINES_FLAG%TYPE := 'N';
2826: l_SCHED_DATE_PUSH_FLAG hz_cust_accounts.SCHED_DATE_PUSH_FLAG%TYPE := 'N';
2827: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2828: l_party_number hz_parties.party_number%TYPE := NULL;
2829: l_customer_key hz_parties.customer_key%TYPE := NULL;
2830: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2831: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2832: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2833: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;

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

2827: l_INVOICE_QUANTITY_RULE hz_cust_accounts.INVOICE_QUANTITY_RULE%TYPE := NULL;
2828: l_party_number hz_parties.party_number%TYPE := NULL;
2829: l_customer_key hz_parties.customer_key%TYPE := NULL;
2830: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2831: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2832: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2833: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2834: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2835: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;

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

2828: l_party_number hz_parties.party_number%TYPE := NULL;
2829: l_customer_key hz_parties.customer_key%TYPE := NULL;
2830: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2831: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2832: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2833: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2834: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2835: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2836: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;

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

2830: l_person_profile_id hz_person_profiles.person_profile_id%TYPE := NULL;
2831: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2832: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2833: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2834: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2835: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2836: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2837: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2838: l_collector_name VARCHAR2(80) := NULL;

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

2831: l_pre_name_adjunct hz_parties.person_pre_name_adjunct%TYPE := NULL;
2832: l_name_suffix hz_parties.person_name_suffix%TYPE := NULL;
2833: l_tax_reference hz_person_profiles.tax_reference%TYPE := NULL;
2834: l_taxpayer_id hz_parties.jgzz_fiscal_code%TYPE := NULL;
2835: l_party_name_phonetic hz_parties.organization_name_phonetic%TYPE := NULL;
2836: l_customer_profile_id hz_customer_profiles.cust_account_profile_id%TYPE := NULL;
2837: l_collector_id hz_customer_profiles.collector_id%TYPE := NULL;
2838: l_collector_name VARCHAR2(80) := NULL;
2839: l_credit_analyst_id hz_customer_profiles.credit_analyst_id%TYPE := NULL;

Line 3012: hz_parties hp

3008: and jrre.category = 'EMPLOYEE'
3009: UNION ALL
3010: select hp.party_id
3011: from jtf_rs_resource_extns jrre,
3012: hz_parties hp
3013: where hp.party_id = jrre.source_id
3014: and jrre.resource_id = l_resource_id
3015: and jrre.category = 'PARTY';
3016:

Line 3051: select hz_parties_s.nextval from dual;

3047: -- select 'select '||select_id||' select_id, '||select_name||' select_name '|| 'from '||from_table sql_str, where_clause
3048: -- from jtf_objects_vl where object_code = l_resource_type;
3049:
3050: CURSOR l_party_number_csr IS
3051: select hz_parties_s.nextval from dual;
3052:
3053: CURSOR l_customer_number_csr IS
3054: select hz_cust_accounts_s.nextval from dual;
3055: