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_APPROVAL_REQUESTS_PVT dependencies on JTF_UM_USERTYPES_VL

Line 43: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

39: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
40: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
41: 'USERTYPE' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,
42: UTREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
43: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
44: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
45: WHERE UTREG.STATUS_CODE = 'PENDING'
46: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
47: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 96: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

92: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
93: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
94: 'USERTYPE' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,
95: UTREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
96: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
97: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
98: WHERE UTREG.STATUS_CODE = 'PENDING'
99: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
100: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 146: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

142: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
143: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
144: 'USERTYPE' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,
145: UTREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
146: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
147: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
148: WHERE UTREG.STATUS_CODE = 'PENDING'
149: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
150: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 198: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

194: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
195: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
196: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE,
197: FU2.USER_NAME APPROVER
198: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
199: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
200: WHERE UTREG.STATUS_CODE = 'PENDING'
201: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
202: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 249: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

245: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
246: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
247: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE,
248: FU2.USER_NAME APPROVER
249: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
250: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
251: WHERE UTREG.STATUS_CODE = 'PENDING'
252: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
253: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 300: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

296: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
297: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
298: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE,
299: FU2.USER_NAME APPROVER
300: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
301: JTF_UM_USERTYPE_REG UTREG, FND_USER FU, FND_USER FU2
302: WHERE UTREG.STATUS_CODE = 'PENDING'
303: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
304: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 540: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP,

536:
537: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
538: FU.USER_NAME USER_NAME, 'USERTYPE' ENTITY_SOURCE,
539: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
540: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP,
541: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU
542:
543: WHERE UTREG.STATUS_CODE = 'PENDING'
544: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID

Line 594: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP,

590:
591: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
592: FU.USER_NAME USER_NAME, 'USERTYPE' ENTITY_SOURCE,
593: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
594: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP,
595: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU
596: WHERE UTREG.STATUS_CODE = 'PENDING'
597: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
598: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 647: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP,

643:
644: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
645: FU.USER_NAME USER_NAME, 'USERTYPE' ENTITY_SOURCE,
646: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
647: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP,
648: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU
649: WHERE UTREG.STATUS_CODE = 'PENDING'
650: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
651: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 698: FROM JTF_UM_USERTYPES_VL UT,

694: SELECT REG_ID, REG_LAST_UPDATE_DATE, USER_NAME, ENTITY_SOURCE, ENTITY_NAME,
695: WF_ITEM_TYPE FROM (
696:
697: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE, FU.USER_NAME USER_NAME, 'USERTYPE' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
698: FROM JTF_UM_USERTYPES_VL UT,
699: JTF_UM_APPROVALS_B AP,
700: HZ_RELATIONSHIPS PREL,
701: JTF_UM_USERTYPE_REG UTREG,
702: FND_USER FU

Line 753: FROM JTF_UM_USERTYPES_VL UT,

749: SELECT REG_ID, REG_LAST_UPDATE_DATE, USER_NAME, ENTITY_SOURCE, ENTITY_NAME,
750: WF_ITEM_TYPE FROM (
751:
752: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE, FU.USER_NAME USER_NAME, 'USERTYPE' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
753: FROM JTF_UM_USERTYPES_VL UT,
754: JTF_UM_APPROVALS_B AP,
755: HZ_RELATIONSHIPS PREL,
756: JTF_UM_USERTYPE_REG UTREG,
757: FND_USER FU

Line 962: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

958: REG_LAST_UPDATE_DATE, FU.USER_NAME USER_NAME,
959: PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
960: 'USERTYPE' ENTITY_SOURCE, UT.USERTYPE_SHORTNAME ENTITY_NAME,
961: UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
962: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
963: JTF_UM_USERTYPE_REG UTREG, FND_USER FU
964: WHERE UTREG.STATUS_CODE = 'PENDING'
965: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
966: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 1002: FROM JTF_UM_USERTYPES_VL UT,

998: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
999: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1000: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
1001: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
1002: FROM JTF_UM_USERTYPES_VL UT,
1003: JTF_UM_APPROVALS_B AP,
1004: HZ_PARTIES PARTY,
1005: JTF_UM_USERTYPE_REG UTREG,
1006: FND_USER FU

Line 1046: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1042: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
1043: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1044: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
1045: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
1046: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1047: JTF_UM_USERTYPE_REG UTREG, FND_USER FU
1048: WHERE UTREG.STATUS_CODE = 'PENDING'
1049: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
1050: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 1087: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1083: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
1084: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1085: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
1086: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
1087: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1088: JTF_UM_USERTYPE_REG UTREG, FND_USER FU
1089: WHERE UTREG.STATUS_CODE = 'PENDING'
1090: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
1091: AND UT.APPROVAL_ID = AP.APPROVAL_ID

Line 1127: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1123: SELECT UTREG.USERTYPE_REG_ID REG_ID, UTREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
1124: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1125: PARTY.PARTY_ID PARTY_ID, 'USERTYPE' ENTITY_SOURCE,
1126: UT.USERTYPE_SHORTNAME ENTITY_NAME, UTREG.WF_ITEM_TYPE WF_ITEM_TYPE
1127: FROM JTF_UM_USERTYPES_VL UT, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1128: JTF_UM_USERTYPE_REG UTREG, FND_USER FU
1129: WHERE UTREG.STATUS_CODE = 'PENDING'
1130: AND UTREG.USERTYPE_ID = UT.USERTYPE_ID
1131: AND UT.APPROVAL_ID = AP.APPROVAL_ID