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.PA_CUSTOMERS_CONTACTS_UTILS dependencies on PA_CUSTOMER_CONTACT_NAMES_V

Line 479: FROM pa_customer_contact_names_v

475:
476: --commented the filter condition on usage_code for Bug#5160623.
477: CURSOR c_ids IS
478: SELECT contact_id
479: FROM pa_customer_contact_names_v
480: WHERE upper(rtrim(contact_name)) = upper(rtrim(p_contact_name)) AND -- Bug 4015644
481: customer_id = p_customer_id /* AND
482: usage_code = decode(p_project_contact_type_code, 'BILLING', 'BILL_TO',
483: 'SHIPPING', 'SHIP_TO', usage_code) */

Line 493: FROM pa_customer_contact_names_v

489: if (p_contact_id = FND_API.G_MISS_NUM) OR (p_contact_id is NULL) then
490: if (p_contact_name is not NULL) then
491: SELECT contact_id
492: INTO x_contact_id
493: FROM pa_customer_contact_names_v
494: WHERE upper(rtrim(contact_name)) = upper(rtrim(p_contact_name)) AND -- Bug 4015644
495: customer_id = p_customer_id AND
496: usage_code = decode(p_project_contact_type_code, 'BILLING', 'BILL_TO',
497: 'SHIPPING', 'SHIP_TO', usage_code)

Line 509: -- FROM pa_customer_contact_names_v

505:
506: -- Commented Following SQL for Performance Bug 4878913 SQL ID : 14907893
507: -- SELECT contact_id
508: -- INTO x_contact_id
509: -- FROM pa_customer_contact_names_v
510: -- WHERE contact_id = p_contact_id AND
511: -- customer_id = p_customer_id AND
512: -- usage_code = decode(p_project_contact_type_code, 'BILLING', 'BILL_TO',
513: -- 'SHIPPING', 'SHIP_TO', usage_code)