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_UM_USERTYPE_CREDENTIALS dependencies on JTF_UM_SUBSCRIPTION_REG

Line 1527: (SELECT SUBSCRIPTION_REG_ID FROM JTF_UM_SUBSCRIPTION_REG SUBREG

1523: WHERE USERTYPE_KEY = l_old_ut_key)
1524: AND UTREG.STATUS_CODE = 'APPROVED'
1525: AND NVL(UTREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE
1526: AND NOT EXISTS
1527: (SELECT SUBSCRIPTION_REG_ID FROM JTF_UM_SUBSCRIPTION_REG SUBREG
1528: WHERE SUBREG.USER_ID = UTREG.USER_ID
1529: AND SUBREG.STATUS_CODE = 'PENDING'
1530: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE
1531: );

Line 1564: FROM JTF_UM_SUBSCRIPTION_REG SUBREG

1560: AND
1561: EXISTS
1562: (
1563: SELECT SUBSCRIPTION_REG_ID
1564: FROM JTF_UM_SUBSCRIPTION_REG SUBREG
1565: WHERE SUBREG.USER_ID = UTREG.USER_ID
1566: AND
1567: SUBREG.STATUS_CODE = 'PENDING'
1568: AND