DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on CS_INCIDENT_LINKS

Line 624: FROM cs_incident_links SrLnkEO

620: (SELECT obj.name RelatedOB_name
621: , SrLnkEO.object_number RelatedOB_Number
622: , csz_servicerequest_util_pvt.get_rel_obj_details(SrLnkEO.object_type,
623: SrLnkEO.object_id) RelatedOB_Description
624: FROM cs_incident_links SrLnkEO
625: , jtf_objects_tl obj
626: WHERE SrLnkEO.subject_id = x_incident_id
627: AND SrLnkEO.subject_type = 'SR'
628: AND SrLnkEO.object_type <> 'SR'

Line 659: FROM cs_incident_links SrLnkEO

655: , (SELECT rs.resource_name
656: FROM jtf_rs_resource_extns_tl rs
657: WHERE rs.resource_id = relSR.incident_owner_id
658: AND rs.language = userenv('LANG')) RelatedSR_Owner
659: FROM cs_incident_links SrLnkEO
660: , cs_sr_link_types_tl ltype
661: , fnd_user fnd1
662: , cs_incidents_all_b relSR
663: , cs_incidents_all_tl tlSR