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

Line 107: FROM hz_parties

103: l_party_number VARCHAR2(30);
104:
105: CURSOR party_num IS
106: SELECT party_number
107: FROM hz_parties
108: WHERE orig_system_reference = 'PREL-'||p_orig_system_contact_ref;
109:
110: CURSOR cont_name IS
111: SELECT party_name

Line 112: FROM hz_parties

108: WHERE orig_system_reference = 'PREL-'||p_orig_system_contact_ref;
109:
110: CURSOR cont_name IS
111: SELECT party_name
112: FROM hz_parties
113: WHERE orig_system_reference = p_orig_system_contact_ref;
114:
115: CURSOR org_name IS
116: SELECT party_name

Line 117: FROM hz_parties

113: WHERE orig_system_reference = p_orig_system_contact_ref;
114:
115: CURSOR org_name IS
116: SELECT party_name
117: FROM hz_parties
118: WHERE party_id = (select party_id
119: from hz_cust_accounts
120: where orig_system_reference = p_orig_system_customer_ref);
121:

Line 156: FROM hz_relationships r, hz_parties s, hz_parties o, hz_parties rel

152:
153: CURSOR c_party_rels IS
154: SELECT r.party_id, r.object_id, o.party_name, r.subject_id, s.party_name,
155: rel.party_number, rel.party_name
156: FROM hz_relationships r, hz_parties s, hz_parties o, hz_parties rel
157: WHERE (r.subject_id = p_party_id OR r.object_id = p_party_id)
158: AND r.party_id IS NOT NULL
159: AND r.subject_table_name = 'HZ_PARTIES'
160: AND r.object_table_name = 'HZ_PARTIES'

Line 159: AND r.subject_table_name = 'HZ_PARTIES'

155: rel.party_number, rel.party_name
156: FROM hz_relationships r, hz_parties s, hz_parties o, hz_parties rel
157: WHERE (r.subject_id = p_party_id OR r.object_id = p_party_id)
158: AND r.party_id IS NOT NULL
159: AND r.subject_table_name = 'HZ_PARTIES'
160: AND r.object_table_name = 'HZ_PARTIES'
161: AND r.directional_flag = 'F'
162: AND r.subject_id = s.party_id
163: AND r.object_id = o.party_id

Line 160: AND r.object_table_name = 'HZ_PARTIES'

156: FROM hz_relationships r, hz_parties s, hz_parties o, hz_parties rel
157: WHERE (r.subject_id = p_party_id OR r.object_id = p_party_id)
158: AND r.party_id IS NOT NULL
159: AND r.subject_table_name = 'HZ_PARTIES'
160: AND r.object_table_name = 'HZ_PARTIES'
161: AND r.directional_flag = 'F'
162: AND r.subject_id = s.party_id
163: AND r.object_id = o.party_id
164: AND r.party_id = rel.party_id;

Line 167: TYPE NAMElist IS TABLE OF HZ_PARTIES.PARTY_NAME%TYPE;

163: AND r.object_id = o.party_id
164: AND r.party_id = rel.party_id;
165:
166: TYPE IDlist IS TABLE OF NUMBER(15);
167: TYPE NAMElist IS TABLE OF HZ_PARTIES.PARTY_NAME%TYPE;
168: TYPE NUMBERlist IS TABLE OF HZ_PARTIES.PARTY_NUMBER%TYPE;
169:
170: i_party_id IDlist;
171: i_object_id IDlist;

Line 168: TYPE NUMBERlist IS TABLE OF HZ_PARTIES.PARTY_NUMBER%TYPE;

164: AND r.party_id = rel.party_id;
165:
166: TYPE IDlist IS TABLE OF NUMBER(15);
167: TYPE NAMElist IS TABLE OF HZ_PARTIES.PARTY_NAME%TYPE;
168: TYPE NUMBERlist IS TABLE OF HZ_PARTIES.PARTY_NUMBER%TYPE;
169:
170: i_party_id IDlist;
171: i_object_id IDlist;
172: i_object_name NAMElist;

Line 194: UPDATE hz_parties

190: i_party_number(i), 1, 360);
191:
192: IF l_party_name <> i_party_name(i) THEN
193:
194: UPDATE hz_parties
195: SET party_name = l_party_name
196: WHERE party_id = i_party_id(i);
197:
198: END IF;

Line 257: FROM hz_parties

253: p_customer_ref VARCHAR2(240);
254:
255: CURSOR c7 IS
256: SELECT party_id
257: FROM hz_parties
258: WHERE orig_system_reference = p_orig_system_contact_ref;
259:
260: CURSOR c2 IS
261: SELECT orig_system_customer_ref

Line 519: FROM hz_parties

515: l_return_code VARCHAR2(5) := 'A3,';
516: l_party_id NUMBER;
517: CURSOR c7 IS
518: SELECT party_id
519: FROM hz_parties
520: WHERE orig_system_reference = p_orig_system_customer_ref;
521: BEGIN
522: IF p_insert_update_flag = 'I' THEN
523: OPEN c7;

Line 549: FROM hz_parties

545: l_party_id NUMBER;
546:
547: CURSOR c8 IS
548: SELECT party_id
549: FROM hz_parties
550: WHERE orig_system_reference = p_orig_system_customer_ref
551: AND party_id = p_request_id /* Bug Fix : 5214454 */
552: -- AND request_id = p_request_id; /* Bug Fix : 1891773 */
553: AND rownum = 1;

Line 576: FROM hz_parties party

572: l_party_type VARCHAR2(30) ;
573: -- For orig_system_party_ref which is having an account
574: CURSOR party_ref_cur IS
575: SELECT party_id
576: FROM hz_parties party
577: WHERE party.orig_system_reference = p_orig_system_customer_ref
578: AND party.PARTY_TYPE = decode(p_person_flag, 'Y', 'PERSON','ORGANIZATION')
579: AND exists (select 'X' from hz_cust_accounts where party_id = party.party_id)
580: AND rownum = 1;

Line 589: FROM hz_parties

585: WHERE orig_system_reference = p_orig_system_customer_ref;
586: --For any orig_system_party_ref
587: CURSOR any_party_ref_cur IS
588: SELECT party_id
589: FROM hz_parties
590: WHERE orig_system_reference = p_orig_system_customer_ref
591: AND PARTY_TYPE = decode(p_person_flag, 'Y', 'PERSON','ORGANIZATION')
592: AND status in ('A','I')
593: AND rownum = 1;

Line 628: FROM hz_parties c

624:
625: -- bug 2098243 - fixed to use a cursor instead of a direct select.
626: CURSOR c9 IS
627: SELECT c.party_id
628: FROM hz_parties c
629: WHERE c.orig_system_reference = p_orig_system_contact_ref
630: AND c.request_id = p_request_id
631: AND NOT EXISTS
632: (SELECT 'X'

Line 660: AND rel.subject_table_name = 'HZ_PARTIES'

656: hz_org_contacts cont
657: WHERE cont.request_id = p_request_id
658: AND cont.orig_system_reference = p_orig_system_contact_ref
659: AND cont.party_relationship_id = rel.relationship_id
660: AND rel.subject_table_name = 'HZ_PARTIES'
661: AND rel.object_table_name = 'HZ_PARTIES';
662: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */
663: BEGIN
664: OPEN c;

Line 661: AND rel.object_table_name = 'HZ_PARTIES';

657: WHERE cont.request_id = p_request_id
658: AND cont.orig_system_reference = p_orig_system_contact_ref
659: AND cont.party_relationship_id = rel.relationship_id
660: AND rel.subject_table_name = 'HZ_PARTIES'
661: AND rel.object_table_name = 'HZ_PARTIES';
662: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */
663: BEGIN
664: OPEN c;
665: FETCH c INTO l_party_id;

Line 685: AND rel.subject_table_name = 'HZ_PARTIES'

681: hz_org_contacts cont
682: WHERE cont.request_id = p_request_id
683: AND cont.orig_system_reference = p_orig_system_contact_ref
684: AND cont.party_relationship_id = rel.relationship_id
685: AND rel.subject_table_name = 'HZ_PARTIES'
686: AND rel.object_table_name = 'HZ_PARTIES';
687: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */
688: BEGIN
689: OPEN c;

Line 686: AND rel.object_table_name = 'HZ_PARTIES';

682: WHERE cont.request_id = p_request_id
683: AND cont.orig_system_reference = p_orig_system_contact_ref
684: AND cont.party_relationship_id = rel.relationship_id
685: AND rel.subject_table_name = 'HZ_PARTIES'
686: AND rel.object_table_name = 'HZ_PARTIES';
687: /* AND rel.directional_flag = 'F'; */ /* Bug No : 2359461 */
688: BEGIN
689: OPEN c;
690: FETCH c INTO l_prel_id;

Line 1651: FROM hz_parties party

1647:
1648:
1649: CURSOR c IS -- Check if the party_number already exists
1650: SELECT decode(party.orig_system_reference,p_orig_system_party_ref,'','Y3,')
1651: FROM hz_parties party
1652: WHERE party.party_number = p_party_number;
1653:
1654: CURSOR c1 IS -- Check if the party_number already exists
1655: SELECT decode(party.orig_system_reference,p_orig_system_customer_ref,'','Y3,')

Line 1656: FROM hz_parties party

1652: WHERE party.party_number = p_party_number;
1653:
1654: CURSOR c1 IS -- Check if the party_number already exists
1655: SELECT decode(party.orig_system_reference,p_orig_system_customer_ref,'','Y3,')
1656: FROM hz_parties party
1657: WHERE party.party_number = p_party_number;
1658:
1659: CURSOR c2 IS -- Check if the party_number already exists in interface table
1660: SELECT decode(NVL(i.orig_system_party_ref,i.orig_system_customer_ref),p_orig_system_party_ref,'','Y3,')

Line 3169: FROM HZ_PARTIES party, ra_customers_interface_all rci -- Bug 4956131

3165: FND_GLOBAL.User_ID CREATED_BY,
3166: SYSDATE LAST_UPDATE_DATE,
3167: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3168: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3169: FROM HZ_PARTIES party, ra_customers_interface_all rci -- Bug 4956131
3170: WHERE party.orig_system_reference = nvl(rci.orig_system_party_ref, rci.orig_system_customer_ref)
3171: AND party.request_id = p_request_id
3172: AND rci.interface_status is null
3173: AND rci.request_id = p_request_id

Line 3246: FROM HZ_PARTIES party, RA_CONTACT_PHONES_INT_ALL rcpi

3242: FND_GLOBAL.User_ID CREATED_BY,
3243: SYSDATE LAST_UPDATE_DATE,
3244: FND_GLOBAL.User_ID LAST_UPDATED_BY,
3245: FND_GLOBAL.Login_ID LAST_UPDATE_LOGIN
3246: FROM HZ_PARTIES party, RA_CONTACT_PHONES_INT_ALL rcpi
3247: WHERE party.orig_system_reference = rcpi.orig_system_contact_ref
3248: AND party.request_id = p_request_id
3249: AND rcpi.interface_status is null
3250: AND rcpi.request_id = p_request_id

Line 3433: hz_parties hzp

3429: ,p_request_id -- REQUEST_ID
3430: ,hz_utility_v2pub.program_application_id -- PROGRAM_APPLICATION_ID
3431: ,hz_utility_v2pub.program_id -- PROGRAM_ID
3432: from ra_customers_interface rci,
3433: hz_parties hzp
3434: WHERE hzp.orig_system_reference = nvl(rci.orig_system_party_ref, rci.orig_system_customer_ref)
3435: and hzp.request_id = p_request_id
3436: AND rci.interface_status is null
3437: AND rci.insert_update_flag = 'I'

Line 3509: hz_parties hzp

3505: ,p_request_id -- REQUEST_ID
3506: ,hz_utility_v2pub.program_application_id-- PROGRAM_APPLICATION_ID
3507: ,hz_utility_v2pub.program_id -- PROGRAM_ID
3508: from ra_customers_interface_all rci, -- Bug 4956131
3509: hz_parties hzp
3510: WHERE hzp.party_id = HZ_CUSTOMER_INT.get_account_party_id(rci.orig_system_party_ref,rci.person_flag,'P')
3511: AND rci.request_id = p_request_id
3512: AND rci.interface_status is null
3513: AND rci.insert_update_flag = 'I'

Line 3530: FROM hz_parties

3526: AND i2.interface_status is null
3527: AND i2.insert_update_flag = 'I')
3528: )
3529: and not exists( SELECT '1'
3530: FROM hz_parties
3531: WHERE party_id = hzp.party_id
3532: AND request_id = p_request_id )
3533: and not exists(
3534: select '1'

Line 3555: /* Bug 11819914 Sync tax_reference in HZ_PARTIES, HZ_PERSON_PROFILES, HZ_ORGANIZATION_PROFILES */

3551: to_date('31-12-4712','DD-MM-YYYY')
3552: )));
3553: END insert_nci_party_usages;
3554:
3555: /* Bug 11819914 Sync tax_reference in HZ_PARTIES, HZ_PERSON_PROFILES, HZ_ORGANIZATION_PROFILES */
3556:
3557: PROCEDURE sync_tax_reference ( p_request_id IN NUMBER
3558: ,x_return_status OUT NOCOPY VARCHAR2
3559: ,x_msg_data OUT NOCOPY VARCHAR2)

Line 3567: TYPE PARTY_ID IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE;

3563: FROM zx_party_tax_profile
3564: WHERE request_id = p_request_id
3565: AND party_type_code ='THIRD_PARTY';
3566:
3567: TYPE PARTY_ID IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE;
3568: TYPE TAX_REFERENCE IS TABLE OF HZ_PARTIES.TAX_REFERENCE%TYPE;
3569:
3570: l_party_id PARTY_ID;
3571: l_tax_reference TAX_REFERENCE;

Line 3568: TYPE TAX_REFERENCE IS TABLE OF HZ_PARTIES.TAX_REFERENCE%TYPE;

3564: WHERE request_id = p_request_id
3565: AND party_type_code ='THIRD_PARTY';
3566:
3567: TYPE PARTY_ID IS TABLE OF HZ_PARTIES.PARTY_ID%TYPE;
3568: TYPE TAX_REFERENCE IS TABLE OF HZ_PARTIES.TAX_REFERENCE%TYPE;
3569:
3570: l_party_id PARTY_ID;
3571: l_tax_reference TAX_REFERENCE;
3572:

Line 3583: UPDATE HZ_PARTIES p

3579: FETCH c_tax_reference BULK COLLECT INTO l_party_id, l_tax_reference ;
3580:
3581: FORALL i IN 1..l_party_id.count
3582:
3583: UPDATE HZ_PARTIES p
3584: SET tax_reference = l_tax_reference(i)
3585: WHERE p.party_id = l_party_id(i);
3586:
3587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of records updated in HZ_PARTIES : ' || l_party_id.count);

Line 3587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of records updated in HZ_PARTIES : ' || l_party_id.count);

3583: UPDATE HZ_PARTIES p
3584: SET tax_reference = l_tax_reference(i)
3585: WHERE p.party_id = l_party_id(i);
3586:
3587: FND_FILE.PUT_LINE(FND_FILE.LOG, 'No. of records updated in HZ_PARTIES : ' || l_party_id.count);
3588:
3589: FORALL i IN 1..l_party_id.count
3590:
3591: UPDATE HZ_PERSON_PROFILES per

Line 3775: ' FROM HZ_PARTIES hz_insert, ra_customers_interface hz_rcia'||

3771:
3772: l_sql_from_valid_party_id := ' FROM ((SELECT hz_insert.party_id, ''THIRD_PARTY'' as party_type_code'||
3773: ',hz_insert.orig_system_reference as intf_party_reference'||
3774: ',NULL as intf_party_site_reference'||
3775: ' FROM HZ_PARTIES hz_insert, ra_customers_interface hz_rcia'||
3776: ' WHERE hz_insert.orig_system_reference = nvl(hz_rcia.orig_system_party_ref, hz_rcia.orig_system_customer_ref)'||
3777: ' AND hz_insert.request_id = hz_rcia.request_id'||
3778: ' AND hz_rcia.interface_status is null'||
3779: ' AND hz_rcia.insert_update_flag = ''I'''||

Line 3814: ' FROM HZ_PARTIES hz_insert, ra_customers_interface hz_rcia'||

3810:
3811: l_sql_select_insert_ptp_prod := 'SELECT party_id, party_type_code, country country_code';
3812:
3813: l_sql_from_insert_ptp_prod := ' FROM ((SELECT hz_insert.party_id, ''THIRD_PARTY'' as party_type_code, hz_insert.country'||
3814: ' FROM HZ_PARTIES hz_insert, ra_customers_interface hz_rcia'||
3815: ' WHERE hz_insert.orig_system_reference = nvl(hz_rcia.orig_system_party_ref, hz_rcia.orig_system_customer_ref)'||
3816: ' AND hz_insert.request_id = hz_rcia.request_id'||
3817: ' AND hz_rcia.interface_status is null'||
3818: ' AND hz_rcia.insert_update_flag = ''I'''||

Line 3850: ' FROM HZ_PARTIES party, RA_CONTACT_PHONES_INTERFACE rcpi' ||

3846: ' AND i2.insert_update_flag = ''I'')))'||
3847: ' UNION ALL ' ||
3848:
3849: '(SELECT party.party_id, ''THIRD_PARTY'' party_type_code, party.country' ||
3850: ' FROM HZ_PARTIES party, RA_CONTACT_PHONES_INTERFACE rcpi' ||
3851: ' WHERE party.orig_system_reference = rcpi.orig_system_contact_ref' ||
3852: ' AND party.request_id = rcpi.request_id'||
3853: ' AND rcpi.interface_status is null'||
3854: ' AND rcpi.insert_update_flag = ''I'''||