eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_GROUP_USAGE_VUHK dependencies on CN_SRP_COMP_GROUPS_V

Line 66: FROM cn_srp_comp_groups_v cscg,

62: intel.period_id,
63: greatest(cscg.start_date_active, intel.start_date) start_date,
64: decode(cscg.end_date_active, null, intel.end_date,
65: Least(cscg.end_date_active, intel.end_date)) end_date
66: FROM cn_srp_comp_groups_v cscg,
67: cn_srp_intel_periods intel
68: WHERE cscg.comp_group_id = p_group_id
69: and intel.salesrep_id = cscg.salesrep_id
70: and cscg.start_date_active <= intel.end_date

Line 311: FROM cn_srp_comp_groups_v cscg,

307: intel.period_id,
308: greatest(cscg.start_date_active, intel.start_date) start_date,
309: decode(cscg.end_date_active, null, intel.end_date,
310: Least(cscg.end_date_active, intel.end_date)) end_date
311: FROM cn_srp_comp_groups_v cscg,
312: cn_srp_intel_periods intel
313: WHERE cscg.comp_group_id = p_group_id
314: and intel.salesrep_id = cscg.salesrep_id
315: and cscg.start_date_active <= intel.end_date