APPS.CSF_ALERTS_PUB dependencies on HZ_PARTIES

Line 2448: hz_parties hp

2444: hp.person_first_name ||' '|| hp.person_last_name contactname,
2445: hp.email_address email
2446: FROM
2447: hz_relationships rel,
2448: hz_parties hp
2449: WHERE
2450: rel.party_id = v_id
2451: AND rel.subject_id = hp.party_id
2452: AND rel.subject_table_name = 'HZ_PARTIES'

Line 2452: AND rel.subject_table_name = 'HZ_PARTIES'

2448: hz_parties hp
2449: WHERE
2450: rel.party_id = v_id
2451: AND rel.subject_id = hp.party_id
2452: AND rel.subject_table_name = 'HZ_PARTIES'
2453: AND rel.subject_type = 'PERSON';
2454:
2455: cursor c_PERSON_contact(v_id number) is
2456: Select PARTY_NAME, EMAIL_ADDRESS from hz_parties where party_id = v_id;

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

2452: AND rel.subject_table_name = 'HZ_PARTIES'
2453: AND rel.subject_type = 'PERSON';
2454:
2455: cursor c_PERSON_contact(v_id number) is
2456: Select PARTY_NAME, EMAIL_ADDRESS from hz_parties where party_id = v_id;
2457:
2458: cursor c_rel_person_phone(v_incident_id number) is
2459: SELECT
2460: hcp.phone_country_code || ' ' || hcp.phone_area_code || ' ' || hcp.phone_number PHONE_NUMBER

Line 2531: l_cust_name hz_parties.party_name%type;

2527: l_sr_summary cs_incidents_all_b.summary%type;
2528: l_product_nr mtl_system_items_vl.concatenated_segments%type;
2529: l_item_serial cs_customer_products_all.current_serial_number%type;
2530: l_item_description mtl_system_items_vl.description%type;
2531: l_cust_name hz_parties.party_name%type;
2532: l_cust_address varchar2(1000);
2533: l_contact_name varchar2(100);
2534: l_contact_phone varchar2(100);
2535: l_contact_email varchar2(250);

Line 2568: hz_parties hp,

2564: jtf_task_priorities_vl jp_vl,
2565: jtf_task_statuses_vl js_vl,
2566: cs_incidents_all c_b,
2567: hz_party_sites hps,
2568: hz_parties hp,
2569: mtl_system_items_vl msi_b,
2570: cs_customer_products_all ccp_all,
2571: cs_hz_sr_contact_points_v chscp
2572: WHERE

Line 2613: hz_parties hp,

2609: jtf_tasks_vl j_vl,
2610: jtf_task_priorities_vl jp_vl,
2611: cs_incidents_all c_b,
2612: hz_party_sites hps,
2613: hz_parties hp,
2614: mtl_system_items_vl msi_b,
2615: cs_customer_products_all ccp_all,
2616: cs_hz_sr_contact_points_v chscp
2617: WHERE

Line 2659: hz_parties hp,

2655: jtf_tasks_vl j_vl,
2656: jtf_task_priorities_vl jp_vl,
2657: cs_incidents_all c_b,
2658: hz_party_sites hps,
2659: hz_parties hp,
2660: mtl_system_items_vl msi_b,
2661: cs_customer_products_all ccp_all,
2662: cs_hz_sr_contact_points_v chscp
2663: WHERE