DBA Data[Home] [Help]

APPS.JTF_TERR_JSP_REPORTS dependencies on JTF_TERRITORY_RESOURCE_PVT

Line 280: select resource_id, WF_NOTIFICATION.SubstituteSpecialChars(jtf_territory_resource_pvt.get_resource_name(

276: from jtf_terr_resources_v jtrv
277: where jtrv.terr_id = ci_terr_id
278: order by resource_name;
279: */
280: select resource_id, WF_NOTIFICATION.SubstituteSpecialChars(jtf_territory_resource_pvt.get_resource_name(
281: RESOURCE_ID , DECODE( RESOURCE_TYPE , 'RS_SUPPLIER', 'RS_SUPPLIER_CONTACT' ,
282: RESOURCE_TYPE ) )) resource_name, resource_type, terr_rsc_id
283: from JTF_TERR_RSC
284: where terr_id = ci_terr_id