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_USERTYPE_CREDENTIALS dependencies on HZ_PARTIES

Line 19: l_party_type HZ_PARTIES.party_type%type;

15: IS
16:
17:
18:
19: l_party_type HZ_PARTIES.party_type%type;
20:
21: p_approval_id NUMBER := -1;
22: p_account_number NUMBER;
23: x_return_status VARCHAR2(100);

Line 180: AND HZR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

176: SELECT FU.CUSTOMER_ID,HZR.SUBJECT_ID,HZR.OBJECT_ID
177: FROM hz_relationships HZR,FND_USER FU
178: WHERE FU.USER_ID = X_USER_ID
179: AND FU.CUSTOMER_ID = HZR.PARTY_ID
180: AND HZR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
181: AND HZR.subject_type = 'PERSON'
182: AND HZR.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
183: AND HZR.object_table_name = 'HZ_PARTIES'
184: AND HZR.START_DATE <= SYSDATE

Line 183: AND HZR.object_table_name = 'HZ_PARTIES'

179: AND FU.CUSTOMER_ID = HZR.PARTY_ID
180: AND HZR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
181: AND HZR.subject_type = 'PERSON'
182: AND HZR.relationship_code in ('EMPLOYEE_OF', 'CONTACT_OF')
183: AND HZR.object_table_name = 'HZ_PARTIES'
184: AND HZR.START_DATE <= SYSDATE
185: AND NVL(HZR.END_DATE, SYSDATE + 1) > SYSDATE
186: AND ( NVL(FU.end_date,SYSDATE+1) > SYSDATE OR to_char(FU.END_DATE) = to_char(FND_API.G_MISS_DATE));
187:

Line 189: l_party_type HZ_PARTIES.party_type%type;

185: AND NVL(HZR.END_DATE, SYSDATE + 1) > SYSDATE
186: AND ( NVL(FU.end_date,SYSDATE+1) > SYSDATE OR to_char(FU.END_DATE) = to_char(FND_API.G_MISS_DATE));
187:
188: l_procedure_name CONSTANT varchar2(30) := 'QUERY_ACCOUNT';
189: l_party_type HZ_PARTIES.party_type%type;
190: l_customer_id NUMBER;
191: P_USERTYPE_KEY VARCHAR2(80);
192: P_ACCOUNT_ROLE_ID NUMBER := -1;
193: P_PARTY_ID NUMBER;

Line 753: l_party_type HZ_PARTIES.party_type%type;

749: CURSOR FIND_APPROVAL IS SELECT APPROVAL_ID FROM JTF_UM_USERTYPES_B
750: WHERE USERTYPE_KEY = P_USERTYPE_KEY
751: AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE);
752:
753: l_party_type HZ_PARTIES.party_type%type;
754:
755: p_approval_id NUMBER := -1;
756: p_account_number NUMBER;
757: x_return_status VARCHAR2(100);

Line 1479: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f

1475: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE
1476: );
1477: /*
1478: CURSOR PENDING_USERS IS SELECT f.user_name, p.party_name, f.email_address
1479: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1480: WHERE UT.USERTYPE_KEY = l_old_ut_key
1481: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1482: AND UTREG.user_id = f.user_Id
1483: AND UTREG.STATUS_CODE = 'PENDING'

Line 1489: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f

1485: AND NVL(utreg.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE;
1486: */
1487: CURSOR PENDING_USERS IS
1488: SELECT f.user_name, p.party_name, f.email_address
1489: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1490: WHERE UT.USERTYPE_KEY = 'PRIMARYUSER'
1491: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1492: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1493: AND R.object_table_name = 'HZ_PARTIES'

Line 1492: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1488: SELECT f.user_name, p.party_name, f.email_address
1489: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1490: WHERE UT.USERTYPE_KEY = 'PRIMARYUSER'
1491: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1492: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1493: AND R.object_table_name = 'HZ_PARTIES'
1494: AND R.START_DATE < SYSDATE
1495: AND NVL(R.END_DATE, SYSDATE + 1) > SYSDATE
1496: AND p.party_id = r.object_id and r.party_id = f.customer_id

Line 1493: AND R.object_table_name = 'HZ_PARTIES'

1489: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1490: WHERE UT.USERTYPE_KEY = 'PRIMARYUSER'
1491: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1492: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1493: AND R.object_table_name = 'HZ_PARTIES'
1494: AND R.START_DATE < SYSDATE
1495: AND NVL(R.END_DATE, SYSDATE + 1) > SYSDATE
1496: AND p.party_id = r.object_id and r.party_id = f.customer_id
1497: AND NVL(utreg.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE

Line 1548: from hz_parties p, hz_relationships r, fnd_user f

1544: -- this code can result in exceptions hence enclosing in a seperate block
1545: -- as the following block is used for logging
1546: BEGIN
1547: select f.user_name, p.party_name, f.email_address into l_user_name, l_org_name, l_email
1548: from hz_parties p, hz_relationships r, fnd_user f
1549: where
1550: p.party_id = r.object_id and r.party_id = f.customer_id
1551: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1552: AND R.object_table_name = 'HZ_PARTIES'

Line 1551: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1547: select f.user_name, p.party_name, f.email_address into l_user_name, l_org_name, l_email
1548: from hz_parties p, hz_relationships r, fnd_user f
1549: where
1550: p.party_id = r.object_id and r.party_id = f.customer_id
1551: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1552: AND R.object_table_name = 'HZ_PARTIES'
1553: AND R.START_DATE < SYSDATE
1554: AND NVL(R.END_DATE, SYSDATE + 1) > SYSDATE
1555: and f.user_id = i.user_id

Line 1552: AND R.object_table_name = 'HZ_PARTIES'

1548: from hz_parties p, hz_relationships r, fnd_user f
1549: where
1550: p.party_id = r.object_id and r.party_id = f.customer_id
1551: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1552: AND R.object_table_name = 'HZ_PARTIES'
1553: AND R.START_DATE < SYSDATE
1554: AND NVL(R.END_DATE, SYSDATE + 1) > SYSDATE
1555: and f.user_id = i.user_id
1556: and r.relationship_code='EMPLOYEE_OF';