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.ASO_VALIDATE_PVT dependencies on HZ_CONTACT_POINTS

Line 5798: FROM HZ_CONTACT_POINTS phone,

5794: CURSOR C_VALIDATE_PHONE_CONTACT IS
5795: SELECT 1 FROM DUAL WHERE EXISTS
5796: (
5797: SELECT phone.contact_point_id
5798: FROM HZ_CONTACT_POINTS phone,
5799: HZ_PARTIES hp
5800: WHERE HP.party_id = p_party_id --When contact is specified
5801: AND phone.owner_table_id = hp.party_id
5802: AND hp.status = 'A'

Line 5815: FROM HZ_CONTACT_POINTS phone,

5811: SELECT 1 FROM DUAL WHERE EXISTS
5812: (
5813:
5814: SELECT phone.contact_point_id
5815: FROM HZ_CONTACT_POINTS phone,
5816: HZ_PARTIES hp
5817: WHERE HP.party_id = p_cust_party_id
5818: AND phone.owner_table_id = hp.party_id
5819: AND hp.status = 'A'