APPS.HZ_CUSTOMER_INT dependencies on RA_CONTACT_PHONES_INTERFACE

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'''||

Line 3856: ' FROM RA_CONTACT_PHONES_INTERFACE i2 '||

3852: ' AND party.request_id = rcpi.request_id'||
3853: ' AND rcpi.interface_status is null'||
3854: ' AND rcpi.insert_update_flag = ''I'''||
3855: ' AND rcpi.rowid = ( SELECT min(i2.rowid)'||
3856: ' FROM RA_CONTACT_PHONES_INTERFACE i2 '||
3857: ' WHERE i2.orig_system_contact_ref = rcpi.orig_system_contact_ref'||
3858: ' AND i2.interface_status is null'||
3859: ' AND i2.request_id = rcpi.request_id'||
3860: ' AND i2.insert_update_flag = ''I'')'||

Line 4041: DELETE FROM RA_CONTACT_PHONES_INTERFACE

4037:
4038: DELETE FROM ra_customers_interface
4039: WHERE interface_status is NULL;
4040:
4041: DELETE FROM RA_CONTACT_PHONES_INTERFACE
4042: WHERE interface_status is null;
4043:
4044: DELETE FROM ra_cust_pay_method_interface
4045: WHERE interface_status is null;

Line 4061: UPDATE ra_contact_phones_interface

4057:
4058: UPDATE ra_customer_profiles_interface
4059: SET request_id = NULL;
4060:
4061: UPDATE ra_contact_phones_interface
4062: SET request_id = NULL;
4063:
4064: UPDATE ra_cust_pay_method_interface
4065: SET request_id = NULL;