DBA Data[Home] [Help]

APPS.JTF_TERR_JSP_REPORTS dependencies on JTF_TERRITORY_RESOURCE_PVT

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

252: from jtf_terr_resources_v jtrv
253: where jtrv.terr_id = ci_terr_id
254: order by resource_name;
255: */
256: select resource_id, WF_NOTIFICATION.SubstituteSpecialChars(jtf_territory_resource_pvt.get_resource_name(
257: RESOURCE_ID , DECODE( RESOURCE_TYPE , 'RS_SUPPLIER', 'RS_SUPPLIER_CONTACT' ,
258: RESOURCE_TYPE ) )) resource_name, resource_type, terr_rsc_id
259: from JTF_TERR_RSC
260: where terr_id = ci_terr_id