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.

[Home] [Help]

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 1414: AND owner_table_name = 'HZ_PARTIES'

1410: '-' ||
1411: phone_number
1412: FROM okx_contact_points_v
1413: WHERE owner_table_id = p_id
1414: AND owner_table_name = 'HZ_PARTIES'
1415: AND contact_point_type = 'PHONE'
1416: AND phone_number IS NOT NULL
1417: ORDER BY DECODE (phone_line_type,
1418: 'GEN', 1,

Line 1470: AND owner_table_name = 'HZ_PARTIES'

1466: '-' ||
1467: phone_number
1468: FROM okx_contact_points_v
1469: WHERE owner_table_id = p_id
1470: AND owner_table_name = 'HZ_PARTIES'
1471: AND contact_point_type IN ('PHONE', 'FAX')
1472: AND phone_line_type = 'FAX';
1473:
1474: CURSOR l_svc_admin_csr

Line 1521: AND hcp.owner_table_name = 'HZ_PARTIES'

1517: okc_contacts kc
1518: WHERE hcp.owner_table_id = kc.object1_id1
1519: AND kc.cro_code = 'BILLING'
1520: AND hcp.contact_point_type='EMAIL'
1521: AND hcp.owner_table_name = 'HZ_PARTIES'
1522: AND hcp.content_source_type = 'USER_ENTERED'
1523: AND hcp.status = 'A'
1524: AND kc.dnz_chr_id= p_contract_id
1525: ORDER BY hcp.primary_flag desc;

Line 2633: hz_parties hzp

2629: IS
2630: SELECT hzp.party_id
2631: FROM hz_cust_account_roles car,
2632: hz_relationships rln,
2633: hz_parties hzp
2634: WHERE car.cust_account_role_id = p_quote_to_contact_id
2635: AND car.party_id = rln.party_id
2636: AND rln.subject_id = hzp.party_id
2637: AND car.role_type = 'CONTACT'

Line 2684: FROM hz_parties

2680: WHERE security_group_key = p_security_grp_key;
2681:
2682: CURSOR csr_get_per_party_name (p_party_id IN NUMBER) IS
2683: SELECT party_name
2684: FROM hz_parties
2685: WHERE party_id = p_party_id;
2686:
2687: l_oks_per_party_name hz_parties.party_name%TYPE;
2688: l_fnd_per_party_name hz_parties.party_name%TYPE;

Line 2687: l_oks_per_party_name hz_parties.party_name%TYPE;

2683: SELECT party_name
2684: FROM hz_parties
2685: WHERE party_id = p_party_id;
2686:
2687: l_oks_per_party_name hz_parties.party_name%TYPE;
2688: l_fnd_per_party_name hz_parties.party_name%TYPE;
2689:
2690: CURSOR csr_get_party_name (p_party_id IN NUMBER) IS
2691: SELECT p.party_name , p.party_id

Line 2688: l_fnd_per_party_name hz_parties.party_name%TYPE;

2684: FROM hz_parties
2685: WHERE party_id = p_party_id;
2686:
2687: l_oks_per_party_name hz_parties.party_name%TYPE;
2688: l_fnd_per_party_name hz_parties.party_name%TYPE;
2689:
2690: CURSOR csr_get_party_name (p_party_id IN NUMBER) IS
2691: SELECT p.party_name , p.party_id
2692: FROM hz_relationships r , hz_parties p

Line 2692: FROM hz_relationships r , hz_parties p

2688: l_fnd_per_party_name hz_parties.party_name%TYPE;
2689:
2690: CURSOR csr_get_party_name (p_party_id IN NUMBER) IS
2691: SELECT p.party_name , p.party_id
2692: FROM hz_relationships r , hz_parties p
2693: WHERE p.party_id = r.object_id
2694: AND r.subject_type='PERSON'
2695: AND r.object_type='ORGANIZATION'
2696: AND r.subject_id = p_party_id;

Line 2698: l_oks_party_name hz_parties.party_name%TYPE;

2694: AND r.subject_type='PERSON'
2695: AND r.object_type='ORGANIZATION'
2696: AND r.subject_id = p_party_id;
2697:
2698: l_oks_party_name hz_parties.party_name%TYPE;
2699: l_fnd_party_name hz_parties.party_name%TYPE;
2700: l_oks_party_id hz_parties.party_id%TYPE;
2701: l_fnd_party_id hz_parties.party_id%TYPE;
2702:

Line 2699: l_fnd_party_name hz_parties.party_name%TYPE;

2695: AND r.object_type='ORGANIZATION'
2696: AND r.subject_id = p_party_id;
2697:
2698: l_oks_party_name hz_parties.party_name%TYPE;
2699: l_fnd_party_name hz_parties.party_name%TYPE;
2700: l_oks_party_id hz_parties.party_id%TYPE;
2701: l_fnd_party_id hz_parties.party_id%TYPE;
2702:
2703: BEGIN

Line 2700: l_oks_party_id hz_parties.party_id%TYPE;

2696: AND r.subject_id = p_party_id;
2697:
2698: l_oks_party_name hz_parties.party_name%TYPE;
2699: l_fnd_party_name hz_parties.party_name%TYPE;
2700: l_oks_party_id hz_parties.party_id%TYPE;
2701: l_fnd_party_id hz_parties.party_id%TYPE;
2702:
2703: BEGIN
2704: -- start debug log

Line 2701: l_fnd_party_id hz_parties.party_id%TYPE;

2697:
2698: l_oks_party_name hz_parties.party_name%TYPE;
2699: l_fnd_party_name hz_parties.party_name%TYPE;
2700: l_oks_party_id hz_parties.party_id%TYPE;
2701: l_fnd_party_id hz_parties.party_id%TYPE;
2702:
2703: BEGIN
2704: -- start debug log
2705: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

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

3327: WHERE user_name = UPPER (TRIM (p_user_name));
3328: ELSIF l_person_party_id <> l_fnd_person_party_id
3329: THEN
3330: -- fnd_user.person_party_id does NOT match oks_person_party_id
3331: -- get the party names from hz_parties and raise error
3332: -- oks person party name
3333: OPEN csr_get_per_party_name (p_party_id => l_person_party_id);
3334: FETCH csr_get_per_party_name INTO l_oks_per_party_name;
3335: CLOSE csr_get_per_party_name;