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.OKS_AUTO_REMINDER dependencies on HZ_PARTIES

Line 112: hz_parties p

108: CURSOR csr_party_dtls
109: IS
110: SELECT r.object1_id1 AS party_id
111: FROM okc_k_party_roles_b r,
112: hz_parties p
113: WHERE p.party_id = r.object1_id1
114: AND r.jtot_object1_code = 'OKX_PARTY'
115: AND r.rle_code IN
116: ('CUSTOMER', 'SUBSCRIBER')

Line 124: hz_parties hp,

120: /*
121: CURSOR l_CustPartyId_csr IS
122: SELECT distinct hp.party_id
123: FROM okc_k_party_roles_b okpr,
124: hz_parties hp,
125: --NPALEPU
126: --08-AUG-2005
127: --TCA Project
128: --Replaced hz_party_relationships table with hz_relationships table

Line 176: AND hzr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

172: hz_relationships hzr
173: WHERE kh.chr_id = p_chr_id
174: AND kh.quote_to_contact_id = rah.contact_id
175: AND rah.party_relationship_id = hzr.relationship_id
176: AND hzr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
177: AND hzr.OBJECT_TABLE_NAME = 'HZ_PARTIES'
178: AND hzr.DIRECTIONAL_FLAG = 'F';
179: --END NPALEPU
180: */

Line 177: AND hzr.OBJECT_TABLE_NAME = 'HZ_PARTIES'

173: WHERE kh.chr_id = p_chr_id
174: AND kh.quote_to_contact_id = rah.contact_id
175: AND rah.party_relationship_id = hzr.relationship_id
176: AND hzr.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
177: AND hzr.OBJECT_TABLE_NAME = 'HZ_PARTIES'
178: AND hzr.DIRECTIONAL_FLAG = 'F';
179: --END NPALEPU
180: */
181:

Line 200: hz_parties hzp

196: IS
197: SELECT hzp.party_id
198: FROM hz_cust_account_roles car,
199: hz_relationships rln,
200: hz_parties hzp
201: WHERE car.cust_account_role_id = p_quote_to_contact_id
202: AND car.party_id = rln.party_id
203: AND rln.subject_id = hzp.party_id
204: AND car.role_type = 'CONTACT'

Line 400: hz_parties hzp,

396: IS
397: SELECT hzp.party_id
398: FROM hz_cust_account_roles car,
399: hz_relationships rln,
400: hz_parties hzp,
401: oks_k_headers_b ks
402: WHERE ks.quote_to_contact_id = car.cust_account_role_id
403: AND car.party_id = rln.party_id
404: AND rln.subject_id = hzp.party_id

Line 1491: AND owner_table_name = 'HZ_PARTIES'

1487: '-' ||
1488: phone_number
1489: FROM okx_contact_points_v
1490: WHERE owner_table_id = p_id
1491: AND owner_table_name = 'HZ_PARTIES'
1492: AND contact_point_type = 'PHONE'
1493: AND phone_number IS NOT NULL
1494: ORDER BY DECODE (phone_line_type,
1495: 'GEN', 1,

Line 1547: AND owner_table_name = 'HZ_PARTIES'

1543: '-' ||
1544: phone_number
1545: FROM okx_contact_points_v
1546: WHERE owner_table_id = p_id
1547: AND owner_table_name = 'HZ_PARTIES'
1548: AND contact_point_type IN ('PHONE', 'FAX')
1549: AND phone_line_type = 'FAX';
1550:
1551: CURSOR l_svc_admin_csr

Line 1598: AND hcp.owner_table_name = 'HZ_PARTIES'

1594: okc_contacts kc
1595: WHERE hcp.owner_table_id = kc.object1_id1
1596: AND kc.cro_code = 'BILLING'
1597: AND hcp.contact_point_type='EMAIL'
1598: AND hcp.owner_table_name = 'HZ_PARTIES'
1599: AND hcp.content_source_type = 'USER_ENTERED'
1600: AND hcp.status = 'A'
1601: AND kc.dnz_chr_id= p_contract_id
1602: ORDER BY hcp.primary_flag desc;

Line 2776: hz_parties hzp

2772: IS
2773: SELECT hzp.party_id
2774: FROM hz_cust_account_roles car,
2775: hz_relationships rln,
2776: hz_parties hzp
2777: WHERE car.cust_account_role_id = p_quote_to_contact_id
2778: AND car.party_id = rln.party_id
2779: AND rln.subject_id = hzp.party_id
2780: AND car.role_type = 'CONTACT'

Line 2827: FROM hz_parties

2823: WHERE security_group_key = p_security_grp_key;
2824:
2825: CURSOR csr_get_per_party_name (p_party_id IN NUMBER) IS
2826: SELECT party_name
2827: FROM hz_parties
2828: WHERE party_id = p_party_id;
2829:
2830: l_oks_per_party_name hz_parties.party_name%TYPE;
2831: l_fnd_per_party_name hz_parties.party_name%TYPE;

Line 2830: l_oks_per_party_name hz_parties.party_name%TYPE;

2826: SELECT party_name
2827: FROM hz_parties
2828: WHERE party_id = p_party_id;
2829:
2830: l_oks_per_party_name hz_parties.party_name%TYPE;
2831: l_fnd_per_party_name hz_parties.party_name%TYPE;
2832:
2833: CURSOR csr_get_party_name (p_party_id IN NUMBER) IS
2834: SELECT p.party_name , p.party_id

Line 2831: l_fnd_per_party_name hz_parties.party_name%TYPE;

2827: FROM hz_parties
2828: WHERE party_id = p_party_id;
2829:
2830: l_oks_per_party_name hz_parties.party_name%TYPE;
2831: l_fnd_per_party_name hz_parties.party_name%TYPE;
2832:
2833: CURSOR csr_get_party_name (p_party_id IN NUMBER) IS
2834: SELECT p.party_name , p.party_id
2835: FROM hz_relationships r , hz_parties p

Line 2835: FROM hz_relationships r , hz_parties p

2831: l_fnd_per_party_name hz_parties.party_name%TYPE;
2832:
2833: CURSOR csr_get_party_name (p_party_id IN NUMBER) IS
2834: SELECT p.party_name , p.party_id
2835: FROM hz_relationships r , hz_parties p
2836: WHERE p.party_id = r.object_id
2837: AND r.subject_type='PERSON'
2838: AND r.object_type='ORGANIZATION'
2839: AND r.subject_id = p_party_id;

Line 2841: l_oks_party_name hz_parties.party_name%TYPE;

2837: AND r.subject_type='PERSON'
2838: AND r.object_type='ORGANIZATION'
2839: AND r.subject_id = p_party_id;
2840:
2841: l_oks_party_name hz_parties.party_name%TYPE;
2842: l_fnd_party_name hz_parties.party_name%TYPE;
2843: l_oks_party_id hz_parties.party_id%TYPE;
2844: l_fnd_party_id hz_parties.party_id%TYPE;
2845: /*bug7207391*/

Line 2842: l_fnd_party_name hz_parties.party_name%TYPE;

2838: AND r.object_type='ORGANIZATION'
2839: AND r.subject_id = p_party_id;
2840:
2841: l_oks_party_name hz_parties.party_name%TYPE;
2842: l_fnd_party_name hz_parties.party_name%TYPE;
2843: l_oks_party_id hz_parties.party_id%TYPE;
2844: l_fnd_party_id hz_parties.party_id%TYPE;
2845: /*bug7207391*/
2846: l_result VARCHAR2(10);

Line 2843: l_oks_party_id hz_parties.party_id%TYPE;

2839: AND r.subject_id = p_party_id;
2840:
2841: l_oks_party_name hz_parties.party_name%TYPE;
2842: l_fnd_party_name hz_parties.party_name%TYPE;
2843: l_oks_party_id hz_parties.party_id%TYPE;
2844: l_fnd_party_id hz_parties.party_id%TYPE;
2845: /*bug7207391*/
2846: l_result VARCHAR2(10);
2847: v_counter NUMBER := 1;

Line 2844: l_fnd_party_id hz_parties.party_id%TYPE;

2840:
2841: l_oks_party_name hz_parties.party_name%TYPE;
2842: l_fnd_party_name hz_parties.party_name%TYPE;
2843: l_oks_party_id hz_parties.party_id%TYPE;
2844: l_fnd_party_id hz_parties.party_id%TYPE;
2845: /*bug7207391*/
2846: l_result VARCHAR2(10);
2847: v_counter NUMBER := 1;
2848: BEGIN

Line 3528: -- get the party names from hz_parties and raise error

3524: ELSE
3525:
3526: fnd_file.put_line (fnd_file.LOG,'Using SSO behavior');
3527: -- fnd_user.person_party_id does NOT match oks_person_party_id
3528: -- get the party names from hz_parties and raise error
3529: -- oks person party name
3530: OPEN csr_get_per_party_name (p_party_id => l_person_party_id);
3531: FETCH csr_get_per_party_name INTO l_oks_per_party_name;
3532: CLOSE csr_get_per_party_name;