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 808: l_party_type HZ_PARTIES.party_type%type;

804: CURSOR FIND_APPROVAL IS SELECT APPROVAL_ID FROM JTF_UM_USERTYPES_B
805: WHERE USERTYPE_KEY = P_USERTYPE_KEY
806: AND (EFFECTIVE_END_DATE IS NULL OR EFFECTIVE_END_DATE > SYSDATE);
807:
808: l_party_type HZ_PARTIES.party_type%type;
809:
810: p_approval_id NUMBER := -1;
811: p_account_number NUMBER;
812: x_return_status VARCHAR2(100);

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

1530: AND NVL(SUBREG.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE
1531: );
1532: /*
1533: CURSOR PENDING_USERS IS SELECT f.user_name, p.party_name, f.email_address
1534: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1535: WHERE UT.USERTYPE_KEY = l_old_ut_key
1536: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1537: AND UTREG.user_id = f.user_Id
1538: AND UTREG.STATUS_CODE = 'PENDING'

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

1540: AND NVL(utreg.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE;
1541: */
1542: CURSOR PENDING_USERS IS
1543: SELECT f.user_name, p.party_name, f.email_address
1544: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1545: WHERE UT.USERTYPE_KEY = 'PRIMARYUSER'
1546: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1547: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1548: AND R.object_table_name = 'HZ_PARTIES'

Line 1547: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1543: SELECT f.user_name, p.party_name, f.email_address
1544: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1545: WHERE UT.USERTYPE_KEY = 'PRIMARYUSER'
1546: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1547: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1548: AND R.object_table_name = 'HZ_PARTIES'
1549: AND R.START_DATE < SYSDATE
1550: AND NVL(R.END_DATE, SYSDATE + 1) > SYSDATE
1551: AND p.party_id = r.object_id and r.party_id = f.customer_id

Line 1548: AND R.object_table_name = 'HZ_PARTIES'

1544: FROM JTF_UM_USERTYPE_REG UTREG, JTF_UM_USERTYPES_B UT, hz_parties p, hz_relationships r, fnd_user f
1545: WHERE UT.USERTYPE_KEY = 'PRIMARYUSER'
1546: AND UT.USERTYPE_ID = UTREG.USERTYPE_ID
1547: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1548: AND R.object_table_name = 'HZ_PARTIES'
1549: AND R.START_DATE < SYSDATE
1550: AND NVL(R.END_DATE, SYSDATE + 1) > SYSDATE
1551: AND p.party_id = r.object_id and r.party_id = f.customer_id
1552: AND NVL(utreg.EFFECTIVE_END_DATE, SYSDATE + 1) > SYSDATE

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

1600: -- this code can result in exceptions hence enclosing in a seperate block
1601: -- as the following block is used for logging
1602: BEGIN
1603: select f.user_name, p.party_name, f.email_address into l_user_name, l_org_name, l_email
1604: from hz_parties p, hz_relationships r, fnd_user f
1605: where
1606: p.party_id = r.object_id and r.party_id = f.customer_id
1607: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1608: AND R.object_table_name = 'HZ_PARTIES'

Line 1607: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

1603: select f.user_name, p.party_name, f.email_address into l_user_name, l_org_name, l_email
1604: from hz_parties p, hz_relationships r, fnd_user f
1605: where
1606: p.party_id = r.object_id and r.party_id = f.customer_id
1607: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1608: AND R.object_table_name = 'HZ_PARTIES'
1609: AND R.START_DATE < SYSDATE
1610: AND NVL(R.END_DATE, SYSDATE + 1) > SYSDATE
1611: and f.user_id = i.user_id

Line 1608: AND R.object_table_name = 'HZ_PARTIES'

1604: from hz_parties p, hz_relationships r, fnd_user f
1605: where
1606: p.party_id = r.object_id and r.party_id = f.customer_id
1607: AND R.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
1608: AND R.object_table_name = 'HZ_PARTIES'
1609: AND R.START_DATE < SYSDATE
1610: AND NVL(R.END_DATE, SYSDATE + 1) > SYSDATE
1611: and f.user_id = i.user_id
1612: and r.relationship_code='EMPLOYEE_OF';