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 HZ_RELATIONSHIPS

Line 340: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL

336: l_party_id HZ_PARTIES.PARTY_ID%TYPE;
337:
338: CURSOR GET_COMPANY_NAME IS
339:
340: SELECT PARTY.PARTY_NAME FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
341: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
342: AND PREL.PARTY_ID = l_party_id
343: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
344: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 541: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU

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
545: AND UT.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 595: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU

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

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 648: HZ_RELATIONSHIPS PREL, JTF_UM_USERTYPE_REG UTREG, FND_USER FU

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

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 700: HZ_RELATIONSHIPS PREL,

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
703:
704: WHERE UTREG.STATUS_CODE = 'PENDING'

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 755: HZ_RELATIONSHIPS PREL,

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
758:
759: WHERE UTREG.STATUS_CODE = 'PENDING'

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 804: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL, FND_USER FU

800: ) pri_requests where rownum < l_rownum order by REG_ID;
801:
802: CURSOR GET_COMPANY_NAME IS
803: SELECT PARTY.PARTY_NAME, PARTY.PARTY_ID
804: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL, FND_USER FU
805: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
806: AND PREL.PARTY_ID = FU.CUSTOMER_ID
807: AND FU.USER_ID = p_approver_user_id
808: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 1164: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL

1160:
1161: CURSOR GET_COMPANY_NAME IS
1162:
1163: SELECT PARTY.PARTY_NAME
1164: FROM HZ_PARTIES PARTY, HZ_RELATIONSHIPS PREL
1165: WHERE PARTY.PARTY_ID = PREL.OBJECT_ID
1166: AND PREL.PARTY_ID = l_party_id
1167: AND PREL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1168: AND PREL.OBJECT_TABLE_NAME = 'HZ_PARTIES'