DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_LINKS

Line 640: FROM cs_incident_links SrLnkEO

636: (SELECT obj.name RelatedOB_name
637: , SrLnkEO.object_number RelatedOB_Number
638: , csz_servicerequest_util_pvt.get_rel_obj_details(SrLnkEO.object_type,
639: SrLnkEO.object_id) RelatedOB_Description
640: FROM cs_incident_links SrLnkEO
641: , jtf_objects_tl obj
642: WHERE SrLnkEO.subject_id = x_incident_id
643: AND SrLnkEO.subject_type = 'SR'
644: AND SrLnkEO.object_type <> 'SR'

Line 675: FROM cs_incident_links SrLnkEO

671: , (SELECT rs.resource_name
672: FROM jtf_rs_resource_extns_tl rs
673: WHERE rs.resource_id = relSR.incident_owner_id
674: AND rs.language = userenv('LANG')) RelatedSR_Owner
675: FROM cs_incident_links SrLnkEO
676: , cs_sr_link_types_tl ltype
677: , fnd_user fnd1
678: , cs_incidents_all_b relSR
679: , cs_incidents_all_tl tlSR