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.CS_KB_WF_PKG dependencies on JTF_RS_RESOURCE_EXTNS

Line 347: jtf_rs_resource_extns,

343: INTO
344: m_temp
345: FROM
346: fnd_user,
347: jtf_rs_resource_extns,
348: jtf_rs_group_members
349: WHERE
350: jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
351: AND

Line 350: jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id

346: fnd_user,
347: jtf_rs_resource_extns,
348: jtf_rs_group_members
349: WHERE
350: jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
351: AND
352: fnd_user.user_id=m_user_id
353: AND
354: jtf_rs_group_members.group_id=m_group_id

Line 356: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate

352: fnd_user.user_id=m_user_id
353: AND
354: jtf_rs_group_members.group_id=m_group_id
355: AND jtf_rs_group_members.DELETE_FLAG <>'Y'
356: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
357: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
358: AND (
359: (jtf_rs_resource_extns.source_id = fnd_user.employee_id
360: AND

Line 357: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate

353: AND
354: jtf_rs_group_members.group_id=m_group_id
355: AND jtf_rs_group_members.DELETE_FLAG <>'Y'
356: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
357: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
358: AND (
359: (jtf_rs_resource_extns.source_id = fnd_user.employee_id
360: AND
361: jtf_rs_resource_extns.category ='EMPLOYEE')

Line 359: (jtf_rs_resource_extns.source_id = fnd_user.employee_id

355: AND jtf_rs_group_members.DELETE_FLAG <>'Y'
356: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
357: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
358: AND (
359: (jtf_rs_resource_extns.source_id = fnd_user.employee_id
360: AND
361: jtf_rs_resource_extns.category ='EMPLOYEE')
362: OR
363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id

Line 361: jtf_rs_resource_extns.category ='EMPLOYEE')

357: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
358: AND (
359: (jtf_rs_resource_extns.source_id = fnd_user.employee_id
360: AND
361: jtf_rs_resource_extns.category ='EMPLOYEE')
362: OR
363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id
364: AND
365: jtf_rs_resource_extns.category ='PARTY'));

Line 363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id

359: (jtf_rs_resource_extns.source_id = fnd_user.employee_id
360: AND
361: jtf_rs_resource_extns.category ='EMPLOYEE')
362: OR
363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id
364: AND
365: jtf_rs_resource_extns.category ='PARTY'));
366:
367:

Line 365: jtf_rs_resource_extns.category ='PARTY'));

361: jtf_rs_resource_extns.category ='EMPLOYEE')
362: OR
363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id
364: AND
365: jtf_rs_resource_extns.category ='PARTY'));
366:
367:
368: -- set return value to TRUE if something is found.
369: if (m_temp = m_user_id) THEN

Line 1726: jtf_rs_resource_extns,

1722: SELECT DISTINCT
1723: fnd_user.user_name,
1724: fnd_user.user_id
1725: FROM fnd_user,
1726: jtf_rs_resource_extns,
1727: jtf_rs_group_members
1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
1729: AND jtf_rs_group_members.group_id = v_group_id
1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'

Line 1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id

1724: fnd_user.user_id
1725: FROM fnd_user,
1726: jtf_rs_resource_extns,
1727: jtf_rs_group_members
1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
1729: AND jtf_rs_group_members.group_id = v_group_id
1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'
1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate

Line 1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate

1727: jtf_rs_group_members
1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
1729: AND jtf_rs_group_members.group_id = v_group_id
1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'
1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id
1734: AND jtf_rs_resource_extns.category = 'EMPLOYEE' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id

Line 1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate

1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
1729: AND jtf_rs_group_members.group_id = v_group_id
1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'
1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id
1734: AND jtf_rs_resource_extns.category = 'EMPLOYEE' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )

Line 1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id

1729: AND jtf_rs_group_members.group_id = v_group_id
1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'
1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id
1734: AND jtf_rs_resource_extns.category = 'EMPLOYEE' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )
1737: );

Line 1734: AND jtf_rs_resource_extns.category = 'EMPLOYEE' )

1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'
1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id
1734: AND jtf_rs_resource_extns.category = 'EMPLOYEE' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )
1737: );
1738:

Line 1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id

1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id
1734: AND jtf_rs_resource_extns.category = 'EMPLOYEE' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )
1737: );
1738:
1739: BEGIN

Line 1736: AND jtf_rs_resource_extns.category = 'PARTY' )

1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id
1734: AND jtf_rs_resource_extns.category = 'EMPLOYEE' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )
1737: );
1738:
1739: BEGIN
1740: