APPS.CS_ERES_INT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 656: FROM jtf_rs_resource_extns_tl rs

652: , tlSR.summary RelatedSR_Summary
653: , SrLnkEO.object_number RelatedSR_Number
654: , severity.name RelatedSR_Severity
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

Line 710: jtf_rs_resource_extns ext_userb,

706: FROM JTF_NOTES_B JNB ,
707: JTF_NOTES_TL JNT ,
708: FND_LOOKUPS FLS ,
709: FND_LOOKUPS FLP,
710: jtf_rs_resource_extns ext_userb,
711: jtf_rs_resource_extns_tl ext_usert,
712: FND_USER fnd1
713: WHERE JNB.JTF_NOTE_ID = JNT.JTF_NOTE_ID
714: AND JNT.LANGUAGE = USERENV('LANG')

Line 711: jtf_rs_resource_extns_tl ext_usert,

707: JTF_NOTES_TL JNT ,
708: FND_LOOKUPS FLS ,
709: FND_LOOKUPS FLP,
710: jtf_rs_resource_extns ext_userb,
711: jtf_rs_resource_extns_tl ext_usert,
712: FND_USER fnd1
713: WHERE JNB.JTF_NOTE_ID = JNT.JTF_NOTE_ID
714: AND JNT.LANGUAGE = USERENV('LANG')
715: AND FLS.LOOKUP_TYPE(+) = 'JTF_NOTE_TYPE'

Line 1108: FROM jtf_rs_resource_extns_tl rs

1104:
1105: -- :Sr_Owner
1106: CURSOR Get_Resource (v_incident_owner_id NUMBER) IS
1107: SELECT rs.resource_name
1108: FROM jtf_rs_resource_extns_tl rs
1109: WHERE rs.resource_id = v_incident_owner_id
1110: AND language = userenv('LANG');
1111:
1112: l_Sr_Owner VARCHAR2(360);

Line 1444: FROM jtf_rs_resource_extns_tl rs

1440: FROM jtf_rs_groups_tl gr
1441: WHERE gr.group_id = sr.owner_group_id
1442: AND gr.LANGUAGE = userenv(''LANG''))Sr_Group
1443: ,(SELECT rs.resource_name
1444: FROM jtf_rs_resource_extns_tl rs
1445: WHERE rs.resource_id = sr.incident_owner_id
1446: AND rs.language = userenv(''LANG'') )Sr_Owner
1447: ,(SELECT problem.meaning
1448: FROM fnd_lookup_values problem