DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENTS_B_SEC

Line 1021: FROM cs_incidents_b_sec sr

1017: ,instance.instance_id
1018: ,sr.cp_component_id
1019: ,sr.inv_subcomponent_id
1020: ,sr.incident_location_type
1021: FROM cs_incidents_b_sec sr
1022: ,cs_incidents_all_tl tl
1023: ,csi_item_instances instance
1024: WHERE sr.incident_id = tl.incident_id
1025: AND tl.language = userenv('lang')

Line 1539: FROM cs_incidents_b_sec sr, cs_incidents_all_tl tl

1535: AND resolution.View_APPLICATION_ID = 170
1536: AND resolution.SECURITY_GROUP_ID = fnd_global.lookup_security_group(resolution.LOOKUP_TYPE,resolution.VIEW_APPLICATION_ID)) Resolution_code
1537: ,tl.summary Problem_summary
1538: ,tl.resolution_summary Resolution_Summary
1539: FROM cs_incidents_b_sec sr, cs_incidents_all_tl tl
1540: WHERE sr.incident_id = tl.incident_id
1541: AND tl.language = userenv(''lang'')
1542: AND sr.incident_id = :INCIDENT_ID' ;
1543: ELSE