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_SUBSCRIPTIONS_VL

Line 60: FROM JTF_UM_SUBSCRIPTIONS_VL SUB,

56: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
57: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
58: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
59: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
60: FROM JTF_UM_SUBSCRIPTIONS_VL SUB,
61: JTF_UM_APPROVALS_B AP,
62: HZ_PARTIES PARTY,
63: JTF_UM_SUBSCRIPTION_REG SUBREG,
64: FND_USER FU,

Line 113: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

109: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
110: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
111: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
112: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
113: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
114: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
115: FND_USER FU2
116: WHERE SUBREG.STATUS_CODE = 'PENDING'
117: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 164: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

160: REG_LAST_UPDATE_DATE, FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE
161: PARTY_TYPE, PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
162: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE,
163: FU2.USER_NAME APPROVER
164: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
165: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
166: FND_USER FU2
167: WHERE SUBREG.STATUS_CODE = 'PENDING'
168: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 215: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

211: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
212: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
213: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
214: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
215: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
216: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
217: FND_USER FU2
218: WHERE SUBREG.STATUS_CODE = 'PENDING'
219: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 266: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

262: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
263: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
264: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
265: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
266: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
267: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
268: FND_USER FU2
269: WHERE SUBREG.STATUS_CODE = 'PENDING'
270: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 317: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

313: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
314: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE, PARTY.PARTY_ID PARTY_ID,
315: 'ENROLLMENT' ENTITY_SOURCE, SUB.SUBSCRIPTION_NAME ENTITY_NAME,
316: SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE, FU2.USER_NAME APPROVER
317: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
318: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,
319: FND_USER FU2
320: WHERE SUBREG.STATUS_CODE = 'PENDING'
321: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 563: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,

559:
560: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
561: FU.USER_NAME USER_NAME, 'ENROLLMENT' ENTITY_SOURCE,
562: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
563: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,
564: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,
565: FND_USER FU, JTF_UM_USERTYPE_REG UTREG
566: WHERE SUBREG.STATUS_CODE = 'PENDING'
567: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 616: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,

612:
613: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
614: FU.USER_NAME USER_NAME, 'ENROLLMENT' ENTITY_SOURCE,
615: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
616: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,
617: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,
618: FND_USER FU, JTF_UM_USERTYPE_REG UTREG
619: WHERE SUBREG.STATUS_CODE = 'PENDING'
620: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 669: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,

665:
666: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
667: FU.USER_NAME USER_NAME,'ENROLLMENT' ENTITY_SOURCE,
668: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
669: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,
670: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,
671: FND_USER FU, JTF_UM_USERTYPE_REG UTREG
672: WHERE SUBREG.STATUS_CODE = 'PENDING'
673: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 724: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,

720:
721: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
722: FU.USER_NAME USER_NAME,'ENROLLMENT' ENTITY_SOURCE,
723: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
724: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,
725: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,
726: FND_USER FU, JTF_UM_USERTYPE_REG UTREG
727: WHERE SUBREG.STATUS_CODE = 'PENDING'
728: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 779: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,

775:
776: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
777: FU.USER_NAME USER_NAME,'ENROLLMENT' ENTITY_SOURCE,
778: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
779: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP,
780: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,
781: FND_USER FU, JTF_UM_USERTYPE_REG UTREG
782: WHERE SUBREG.STATUS_CODE = 'PENDING'
783: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID

Line 979: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

975: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
976: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
977: PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
978: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
979: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
980: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
981: WHERE SUBREG.STATUS_CODE = 'PENDING'
982: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
983: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 1022: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1018: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
1019: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1020: PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
1021: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
1022: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1023: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
1024: WHERE SUBREG.STATUS_CODE = 'PENDING'
1025: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
1026: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 1063: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1059: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
1060: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1061: PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
1062: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
1063: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1064: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
1065: WHERE SUBREG.STATUS_CODE = 'PENDING'
1066: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
1067: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 1104: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1100: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
1101: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1102: PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
1103: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
1104: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1105: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
1106: WHERE SUBREG.STATUS_CODE = 'PENDING'
1107: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
1108: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 1144: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,

1140: SELECT SUBREG.SUBSCRIPTION_REG_ID REG_ID, SUBREG.LAST_UPDATE_DATE REG_LAST_UPDATE_DATE,
1141: FU.USER_NAME USER_NAME, PARTY.PARTY_TYPE PARTY_TYPE,
1142: PARTY.PARTY_ID PARTY_ID, 'ENROLLMENT' ENTITY_SOURCE,
1143: SUB.SUBSCRIPTION_NAME ENTITY_NAME, SUBREG.WF_ITEM_TYPE WF_ITEM_TYPE
1144: FROM JTF_UM_SUBSCRIPTIONS_VL SUB, JTF_UM_APPROVALS_B AP, HZ_PARTIES PARTY,
1145: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG
1146: WHERE SUBREG.STATUS_CODE = 'PENDING'
1147: AND SUBREG.SUBSCRIPTION_ID = SUB.SUBSCRIPTION_ID
1148: AND SUB.APPROVAL_ID = AP.APPROVAL_ID