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.PV_CONTACT_USER_BATCH_PUB dependencies on JTF_UM_USERTYPES_B

Line 282: select usertype_id ,nvl(approval_id,-1) from JTF_UM_USERTYPES_B where usertype_key=user_type;

278:
279:
280:
281: CURSOR user_type_id (user_type VARCHAR2) IS
282: select usertype_id ,nvl(approval_id,-1) from JTF_UM_USERTYPES_B where usertype_key=user_type;
283:
284:
285:
286: CURSOR enrollment_id (user_type VARCHAR2) IS

Line 287: select a.subscription_id from JTF_UM_USERTYPE_SUBSCRIP a,JTF_UM_SUBSCRIPTIONS_B b,JTF_UM_USERTYPES_B c

283:
284:
285:
286: CURSOR enrollment_id (user_type VARCHAR2) IS
287: select a.subscription_id from JTF_UM_USERTYPE_SUBSCRIP a,JTF_UM_SUBSCRIPTIONS_B b,JTF_UM_USERTYPES_B c
288: where a.subscription_id=b.subscription_id
289: and c.usertype_key=user_type
290: and a.usertype_id=c.usertype_id;
291:

Line 303: JTF_UM_USERTYPES_B c

299:
300: CURSOR USERTYPE_RESP(user_type VARCHAR2) is select FR.RESPONSIBILITY_ID, UT.APPLICATION_ID, FR.VERSION
301: FROM JTF_UM_USERTYPE_RESP UT,
302: FND_RESPONSIBILITY_VL FR,
303: JTF_UM_USERTYPES_B c
304: WHERE c.usertype_key=user_type
305: and UT.USERTYPE_ID = c.usertype_id
306: AND FR.APPLICATION_ID = UT.APPLICATION_ID
307: AND FR.RESPONSIBILITY_KEY = UT.RESPONSIBILITY_KEY

Line 1397: select usertype_id ,nvl(approval_id,-1) from JTF_UM_USERTYPES_B where usertype_key=user_type;

1393: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
1394: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
1395:
1396: CURSOR user_type_id (user_type VARCHAR2) IS
1397: select usertype_id ,nvl(approval_id,-1) from JTF_UM_USERTYPES_B where usertype_key=user_type;
1398:
1399: CURSOR enrollment_id (user_type VARCHAR2) IS
1400: select a.subscription_id from JTF_UM_USERTYPE_SUBSCRIP a,JTF_UM_SUBSCRIPTIONS_B b,JTF_UM_USERTYPES_B c
1401: where a.subscription_id=b.subscription_id

Line 1400: select a.subscription_id from JTF_UM_USERTYPE_SUBSCRIP a,JTF_UM_SUBSCRIPTIONS_B b,JTF_UM_USERTYPES_B c

1396: CURSOR user_type_id (user_type VARCHAR2) IS
1397: select usertype_id ,nvl(approval_id,-1) from JTF_UM_USERTYPES_B where usertype_key=user_type;
1398:
1399: CURSOR enrollment_id (user_type VARCHAR2) IS
1400: select a.subscription_id from JTF_UM_USERTYPE_SUBSCRIP a,JTF_UM_SUBSCRIPTIONS_B b,JTF_UM_USERTYPES_B c
1401: where a.subscription_id=b.subscription_id
1402: and c.usertype_key=user_type
1403: and a.usertype_id=c.usertype_id;
1404:

Line 1419: JTF_UM_USERTYPES_B c

1415:
1416: CURSOR USERTYPE_RESP(user_type VARCHAR2) is select FR.RESPONSIBILITY_ID, UT.APPLICATION_ID, FR.VERSION
1417: FROM JTF_UM_USERTYPE_RESP UT,
1418: FND_RESPONSIBILITY_VL FR,
1419: JTF_UM_USERTYPES_B c
1420: WHERE c.usertype_key=user_type
1421: and UT.USERTYPE_ID = c.usertype_id
1422: AND FR.APPLICATION_ID = UT.APPLICATION_ID
1423: AND FR.RESPONSIBILITY_KEY = UT.RESPONSIBILITY_KEY

Line 1991: select usertype_id ,nvl(approval_id,-1) from JTF_UM_USERTYPES_B where usertype_key=user_type;

1987: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.relationship_rec_type;
1988: l_org_contact_rec HZ_PARTY_CONTACT_V2PUB.org_contact_rec_type;
1989:
1990: CURSOR user_type_id (user_type VARCHAR2) IS
1991: select usertype_id ,nvl(approval_id,-1) from JTF_UM_USERTYPES_B where usertype_key=user_type;
1992:
1993: CURSOR user_type_reg_id (USERNAME VARCHAR2 , USERTYPE VARCHAR2) IS
1994: select USERTYPE_REG_ID from jtf_um_usertype_reg reg, fnd_user fu, JTF_UM_USERTYPES_B type where
1995: fu.user_id=reg.user_id and fu.user_name=username and

Line 1994: select USERTYPE_REG_ID from jtf_um_usertype_reg reg, fnd_user fu, JTF_UM_USERTYPES_B type where

1990: CURSOR user_type_id (user_type VARCHAR2) IS
1991: select usertype_id ,nvl(approval_id,-1) from JTF_UM_USERTYPES_B where usertype_key=user_type;
1992:
1993: CURSOR user_type_reg_id (USERNAME VARCHAR2 , USERTYPE VARCHAR2) IS
1994: select USERTYPE_REG_ID from jtf_um_usertype_reg reg, fnd_user fu, JTF_UM_USERTYPES_B type where
1995: fu.user_id=reg.user_id and fu.user_name=username and
1996: type.usertype_key=USERTYPE and
1997: reg.usertype_id=type.usertype_id and
1998: reg.user_id=fu.user_id;

Line 2003: select a.subscription_id from JTF_UM_USERTYPE_SUBSCRIP a,JTF_UM_SUBSCRIPTIONS_B b,JTF_UM_USERTYPES_B c

1999: CURSOR get_user_id(l_user_name VARCHAR2) is
2000: select user_id from fnd_user where user_name=l_user_name;
2001:
2002: CURSOR enrollment_id (user_type VARCHAR2) IS
2003: select a.subscription_id from JTF_UM_USERTYPE_SUBSCRIP a,JTF_UM_SUBSCRIPTIONS_B b,JTF_UM_USERTYPES_B c
2004: where a.subscription_id=b.subscription_id
2005: and c.usertype_key=user_type
2006: and a.usertype_id=c.usertype_id;
2007:

Line 2025: JTF_UM_USERTYPES_B c

2021:
2022: CURSOR USERTYPE_RESP(user_type VARCHAR2) is select FR.RESPONSIBILITY_ID, UT.APPLICATION_ID, FR.VERSION
2023: FROM JTF_UM_USERTYPE_RESP UT,
2024: FND_RESPONSIBILITY_VL FR,
2025: JTF_UM_USERTYPES_B c
2026: WHERE c.usertype_key=user_type
2027: and UT.USERTYPE_ID = c.usertype_id
2028: AND FR.APPLICATION_ID = UT.APPLICATION_ID
2029: AND FR.RESPONSIBILITY_KEY = UT.RESPONSIBILITY_KEY