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.CSF_ALERTS_PUB dependencies on MTL_SYSTEM_ITEMS_VL

Line 2538: l_product_nr mtl_system_items_vl.concatenated_segments%type;

2534: l_priority jtf_task_priorities_vl.name%type;
2535: l_asgm_sts_name jtf_task_statuses_vl.name%type;
2536: l_sr_number cs_incidents_all_b.incident_number%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);

Line 2540: l_item_description mtl_system_items_vl.description%type;

2536: l_sr_number cs_incidents_all_b.incident_number%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);

Line 2579: mtl_system_items_vl msi_b,

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
2583: jta.task_assignment_id = v_task_assgn_id

Line 2624: mtl_system_items_vl msi_b,

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
2628: jtb.task_id = v_task_id

Line 2670: mtl_system_items_vl msi_b,

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
2674: jtb.task_id = v_task_id