DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENTS_B_SEC

Line 950: FROM cs_incidents_b_sec sr

946: ,instance.instance_id
947: ,sr.cp_component_id
948: ,sr.inv_subcomponent_id
949: ,sr.incident_location_type
950: FROM cs_incidents_b_sec sr
951: ,cs_incidents_all_tl tl
952: ,csi_item_instances instance
953: WHERE sr.incident_id = tl.incident_id
954: AND tl.language = userenv('lang')

Line 1463: FROM cs_incidents_b_sec sr, cs_incidents_all_tl tl

1459: AND resolution.View_APPLICATION_ID = 170
1460: AND resolution.SECURITY_GROUP_ID = fnd_global.lookup_security_group(resolution.LOOKUP_TYPE,resolution.VIEW_APPLICATION_ID)) Resolution_code
1461: ,tl.summary Problem_summary
1462: ,tl.resolution_summary Resolution_Summary
1463: FROM cs_incidents_b_sec sr, cs_incidents_all_tl tl
1464: WHERE sr.incident_id = tl.incident_id
1465: AND tl.language = userenv(''lang'')
1466: AND sr.incident_id = :INCIDENT_ID' ;
1467: ELSE