DBA Data[Home] [Help]

APPS.JTF_UM_APPROVAL_REQUESTS_PVT dependencies on JTF_UM_SUBSCRIPTION_REG

Line 63: JTF_UM_SUBSCRIPTION_REG SUBREG,

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,
65: JTF_UM_USERTYPE_REG UTREG,
66: FND_USER FU2
67: WHERE SUBREG.STATUS_CODE = 'PENDING'

Line 114: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,

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
118: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 165: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,

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
169: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 216: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,

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
220: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 267: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,

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
271: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 318: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG,

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
322: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 564: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,

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
568: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 617: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,

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
621: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 670: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,

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
674: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 725: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,

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
729: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 780: HZ_RELATIONSHIPS PREL, JTF_UM_SUBSCRIPTION_REG SUBREG,

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
784: AND SUB.APPROVAL_ID = AP.APPROVAL_ID

Line 980: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG

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
984: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1023: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG

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
1027: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1064: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG

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
1068: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1105: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG

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
1109: AND AP.USE_PENDING_REQ_FLAG = 'Y'

Line 1145: JTF_UM_SUBSCRIPTION_REG SUBREG, FND_USER FU, JTF_UM_USERTYPE_REG UTREG

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
1149: AND AP.USE_PENDING_REQ_FLAG = 'Y'