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.CSFW_TASKS_PUB dependencies on HZ_RELATIONSHIPS

Line 1498: FROM Hz_Relationships r

1494: AND ( s.party_id = p_customer_id
1495: -- or one of its relationships
1496: OR s.party_id IN (
1497: SELECT r.party_id
1498: FROM Hz_Relationships r
1499: WHERE r.object_id = p_customer_id
1500: AND r.status = 'A'
1501: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(r.START_DATE, SYSDATE)) AND TRUNC(NVL(r.END_DATE, SYSDATE)) )
1502: -- or one of its Related parties

Line 1508: Hz_Relationships r

1504: SELECT sub.party_id
1505: FROM Hz_Parties p,
1506: Hz_Parties sub,
1507: Hz_Parties obj,
1508: Hz_Relationships r
1509: WHERE obj.party_id = p_customer_id
1510: AND sub.status = 'A'
1511: AND sub.party_type IN ('PERSON','ORGANIZATION')
1512: AND p.party_id = r.party_id