APPS.CSF_ALERTS_PUB dependencies on HZ_PARTIES

Line 2458: hz_parties hp

2454: hp.person_first_name ||' '|| hp.person_last_name contactname,
2455: hp.email_address email
2456: FROM
2457: hz_relationships rel,
2458: hz_parties hp
2459: WHERE
2460: rel.party_id = v_id
2461: AND rel.subject_id = hp.party_id
2462: AND rel.subject_table_name = 'HZ_PARTIES'

Line 2462: AND rel.subject_table_name = 'HZ_PARTIES'

2458: hz_parties hp
2459: WHERE
2460: rel.party_id = v_id
2461: AND rel.subject_id = hp.party_id
2462: AND rel.subject_table_name = 'HZ_PARTIES'
2463: AND rel.subject_type = 'PERSON';
2464:
2465: cursor c_PERSON_contact(v_id number) is
2466: Select PARTY_NAME, EMAIL_ADDRESS from hz_parties where party_id = v_id;

Line 2466: Select PARTY_NAME, EMAIL_ADDRESS from hz_parties where party_id = v_id;

2462: AND rel.subject_table_name = 'HZ_PARTIES'
2463: AND rel.subject_type = 'PERSON';
2464:
2465: cursor c_PERSON_contact(v_id number) is
2466: Select PARTY_NAME, EMAIL_ADDRESS from hz_parties where party_id = v_id;
2467:
2468: cursor c_rel_person_phone(v_incident_id number) is
2469: SELECT
2470: hcp.phone_country_code || ' ' || hcp.phone_area_code || ' ' || hcp.phone_number PHONE_NUMBER

Line 2541: l_cust_name hz_parties.party_name%type;

2537: l_sr_summary cs_incidents_all_tl.summary%type;
2538: l_product_nr mtl_system_items_vl.concatenated_segments%type;
2539: l_item_serial cs_customer_products_all.current_serial_number%type;
2540: l_item_description mtl_system_items_vl.description%type;
2541: l_cust_name hz_parties.party_name%type;
2542: l_cust_address varchar2(1000);
2543: l_contact_name varchar2(100);
2544: l_contact_phone varchar2(100);
2545: l_contact_email varchar2(250);

Line 2578: hz_parties hp,

2574: jtf_task_priorities_vl jp_vl,
2575: jtf_task_statuses_vl js_vl,
2576: cs_incidents_all c_b,
2577: hz_party_sites hps,
2578: hz_parties hp,
2579: mtl_system_items_vl msi_b,
2580: cs_customer_products_all ccp_all,
2581: cs_hz_sr_contact_points_v chscp
2582: WHERE

Line 2623: hz_parties hp,

2619: jtf_tasks_vl j_vl,
2620: jtf_task_priorities_vl jp_vl,
2621: cs_incidents_all c_b,
2622: hz_party_sites hps,
2623: hz_parties hp,
2624: mtl_system_items_vl msi_b,
2625: cs_customer_products_all ccp_all,
2626: cs_hz_sr_contact_points_v chscp
2627: WHERE

Line 2669: hz_parties hp,

2665: jtf_tasks_vl j_vl,
2666: jtf_task_priorities_vl jp_vl,
2667: cs_incidents_all c_b,
2668: hz_party_sites hps,
2669: hz_parties hp,
2670: mtl_system_items_vl msi_b,
2671: cs_customer_products_all ccp_all,
2672: cs_hz_sr_contact_points_v chscp
2673: WHERE