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 CS_CUSTOMER_PRODUCTS_ALL

Line 2539: l_item_serial cs_customer_products_all.current_serial_number%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);
2543: l_contact_name varchar2(100);

Line 2580: cs_customer_products_all ccp_all,

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
2584: and jta.task_id = jtb.task_id

Line 2625: cs_customer_products_all ccp_all,

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
2629: and j_vl.task_id = jtb.task_id

Line 2671: cs_customer_products_all ccp_all,

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
2675: and jtab.task_audit_id = v_task_audit_id