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 2528: l_product_nr mtl_system_items_vl.concatenated_segments%type;

2524: l_priority jtf_task_priorities_vl.name%type;
2525: l_asgm_sts_name jtf_task_statuses_vl.name%type;
2526: l_sr_number cs_incidents_all_b.incident_number%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);

Line 2530: l_item_description mtl_system_items_vl.description%type;

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

Line 2569: mtl_system_items_vl msi_b,

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

Line 2614: mtl_system_items_vl msi_b,

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

Line 2660: mtl_system_items_vl msi_b,

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