APPS.CSM_SERVICE_HISTORY_EVENT_PKG dependencies on CS_INCIDENTS_ALL_B

Line 173: FROM CS_INCIDENTS_ALL_B

169: SELECT CUSTOMER_PRODUCT_ID
170: , INSTALL_SITE_ID
171: , CUSTOMER_ID
172: , INCIDENT_LOCATION_ID
173: FROM CS_INCIDENTS_ALL_B
174: WHERE INCIDENT_ID = b_incident_id;
175:
176: r_sr_type c_sr_type%ROWTYPE;
177:

Line 199: FROM CS_INCIDENTS_ALL_B inc

195: b_customer_product_id NUMBER )
196: IS
197: SELECT DISTINCT inc.INCIDENT_ID
198: , inc.CLOSE_DATE
199: FROM CS_INCIDENTS_ALL_B inc
200: , JTF_TASKS_B tk
201: , JTF_TASK_ASSIGNMENTS ta
202: , CS_INCIDENT_STATUSES_B ists
203: , JTF_TASK_TYPES_B tt

Line 233: FROM CS_INCIDENTS_ALL_B inc

229: b_INCIDENT_LOCATION_ID NUMBER )
230: IS
231: SELECT DISTINCT inc.INCIDENT_ID
232: , inc.CLOSE_DATE
233: FROM CS_INCIDENTS_ALL_B inc
234: , JTF_TASKS_B tk
235: , JTF_TASK_ASSIGNMENTS ta
236: , CS_INCIDENT_STATUSES_B ists
237: , JTF_TASK_TYPES_B tt

Line 442: , CS_INCIDENTS_ALL_B inc

438: IS
439: SELECT acc.INCIDENT_ID
440: , acc.USER_ID
441: FROM CSM_INCIDENTS_ALL_ACC acc
442: , CS_INCIDENTS_ALL_B inc
443: , CS_INCIDENT_STATUSES_b cis
444: , JTF_TASKS_B tsk
445: , JTF_TASK_ASSIGNMENTS ta
446: , JTF_RS_RESOURCE_EXTNS rs

Line 688: FROM cs_incidents_all_b ciab

684: IS
685: SELECT ciab.incident_id
686: , ciia.user_id
687: , ciia.instance_id
688: FROM cs_incidents_all_b ciab
689: , cs_incident_statuses_b cisb
690: , csm_item_instances_acc ciia
691: , jtf_tasks_b jtb
692: WHERE ciab.customer_product_id = ciia.instance_id