DBA Data[Home] [Help]

APPS.CS_ERES_INT_PKG dependencies on JTF_OBJECTS_TL

Line 641: , jtf_objects_tl obj

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

Line 832: , jtf_objects_tl obj_vl

828: , jtf_tasks_b jtf2
829: , jtf_task_types_tl type
830: , jtf_task_priorities_tl priority
831: , JTF_TASK_STATUSES_TL statusT, JTF_TASK_STATUSES_B statusB
832: , jtf_objects_tl obj_vl
833: WHERE jtf1B.source_object_type_code='SR'
834: AND jtf1B.source_object_id = x_incident_id
835: AND jtf1B.TASK_ID = jtf1T.TASK_ID
836: AND jtf1T.LANGUAGE = userenv('LANG')

Line 1409: FROM jtf_objects_tl o,

1405:
1406: -- :Resource_Type
1407: CURSOR Get_Res_Type (v_resource_type VARCHAR2) IS
1408: SELECT name
1409: FROM jtf_objects_tl o,
1410: jtf_object_usages ou
1411: WHERE o.object_code = ou.object_code
1412: AND ou.object_user_code = 'RESOURCES'
1413: AND o.object_code = v_resource_type