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 1472: (SELECT SUBSCRIPTION_REG_ID FROM JTF_UM_SUBSCRIPTION_REG SUBREG

1468: WHERE USERTYPE_KEY = l_old_ut_key)
1469: AND UTREG.STATUS_CODE = 'APPROVED'
1470: AND NVL(UTREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE
1471: AND NOT EXISTS
1472: (SELECT SUBSCRIPTION_REG_ID FROM JTF_UM_SUBSCRIPTION_REG SUBREG
1473: WHERE SUBREG.USER_ID = UTREG.USER_ID
1474: AND SUBREG.STATUS_CODE = 'PENDING'
1475: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE
1476: );

Line 1508: FROM JTF_UM_SUBSCRIPTION_REG SUBREG

1504: AND
1505: EXISTS
1506: (
1507: SELECT SUBSCRIPTION_REG_ID
1508: FROM JTF_UM_SUBSCRIPTION_REG SUBREG
1509: WHERE SUBREG.USER_ID = UTREG.USER_ID
1510: AND
1511: SUBREG.STATUS_CODE = 'PENDING'
1512: AND