DBA Data[Home] [Help]

APPS.HZ_CUSTOMER_INT dependencies on RA_CONTACT_PHONES_INT_ALL

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 3253: FROM RA_CONTACT_PHONES_INT_ALL i2

3249: AND rcpi.interface_status is null
3250: AND rcpi.request_id = p_request_id
3251: AND rcpi.insert_update_flag = 'I'
3252: AND rcpi.rowid = ( SELECT min(i2.rowid)
3253: FROM RA_CONTACT_PHONES_INT_ALL i2
3254: WHERE i2.orig_system_contact_ref = rcpi.orig_system_contact_ref
3255: AND i2.interface_status is null
3256: AND i2.request_id = p_request_id
3257: AND i2.insert_update_flag = 'I')