DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on JTF_OBJECTS_TL

Line 625: , jtf_objects_tl obj

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'
629: AND obj.object_code (+) = SrLnkEO.object_type

Line 785: , jtf_objects_tl obj_vl

781: , jtf_tasks_b jtf2
782: , jtf_task_types_tl type
783: , jtf_task_priorities_tl priority
784: , JTF_TASK_STATUSES_TL statusT, JTF_TASK_STATUSES_B statusB
785: , jtf_objects_tl obj_vl
786: WHERE jtf1B.source_object_type_code='SR'
787: AND jtf1B.source_object_id = x_incident_id
788: AND jtf1B.TASK_ID = jtf1T.TASK_ID
789: AND jtf1T.LANGUAGE = userenv('LANG')

Line 1338: FROM jtf_objects_tl o,

1334:
1335: -- :Resource_Type
1336: CURSOR Get_Res_Type (v_resource_type VARCHAR2) IS
1337: SELECT name
1338: FROM jtf_objects_tl o,
1339: jtf_object_usages ou
1340: WHERE o.object_code = ou.object_code
1341: AND ou.object_user_code = 'RESOURCES'
1342: AND o.object_code = v_resource_type