APPS.CS_ERES_INT_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 672: FROM jtf_rs_resource_extns_tl rs

668: , tlSR.summary RelatedSR_Summary
669: , SrLnkEO.object_number RelatedSR_Number
670: , severity.name RelatedSR_Severity
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

Line 732: jtf_rs_resource_extns ext_userb,

728: FROM JTF_NOTES_B JNB ,
729: JTF_NOTES_TL JNT ,
730: FND_LOOKUPS FLS ,
731: FND_LOOKUPS FLP,
732: jtf_rs_resource_extns ext_userb,
733: jtf_rs_resource_extns_tl ext_usert,
734: FND_USER fnd1
735: WHERE JNB.JTF_NOTE_ID = JNT.JTF_NOTE_ID
736: AND JNT.LANGUAGE = USERENV('LANG')

Line 733: jtf_rs_resource_extns_tl ext_usert,

729: JTF_NOTES_TL JNT ,
730: FND_LOOKUPS FLS ,
731: FND_LOOKUPS FLP,
732: jtf_rs_resource_extns ext_userb,
733: jtf_rs_resource_extns_tl ext_usert,
734: FND_USER fnd1
735: WHERE JNB.JTF_NOTE_ID = JNT.JTF_NOTE_ID
736: AND JNT.LANGUAGE = USERENV('LANG')
737: AND FLS.LOOKUP_TYPE(+) = 'JTF_NOTE_TYPE'

Line 1179: FROM jtf_rs_resource_extns_tl rs

1175:
1176: -- :Sr_Owner
1177: CURSOR Get_Resource (v_incident_owner_id NUMBER) IS
1178: SELECT rs.resource_name
1179: FROM jtf_rs_resource_extns_tl rs
1180: WHERE rs.resource_id = v_incident_owner_id
1181: AND language = userenv('LANG');
1182:
1183: l_Sr_Owner VARCHAR2(360);

Line 1520: FROM jtf_rs_resource_extns_tl rs

1516: FROM jtf_rs_groups_tl gr
1517: WHERE gr.group_id = sr.owner_group_id
1518: AND gr.LANGUAGE = userenv(''LANG''))Sr_Group
1519: ,(SELECT rs.resource_name
1520: FROM jtf_rs_resource_extns_tl rs
1521: WHERE rs.resource_id = sr.incident_owner_id
1522: AND rs.language = userenv(''LANG'') )Sr_Owner
1523: ,(SELECT problem.meaning
1524: FROM fnd_lookup_values problem