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 1516: FROM Hz_Relationships r

1512: AND ( s.party_id = p_customer_id
1513: -- or one of its relationships
1514: OR s.party_id IN (
1515: SELECT r.party_id
1516: FROM Hz_Relationships r
1517: WHERE r.object_id = p_customer_id
1518: AND r.status = 'A'
1519: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(r.START_DATE, SYSDATE)) AND TRUNC(NVL(r.END_DATE, SYSDATE)) )
1520: -- or one of its Related parties

Line 1526: Hz_Relationships r

1522: SELECT sub.party_id
1523: FROM Hz_Parties p,
1524: Hz_Parties sub,
1525: Hz_Parties obj,
1526: Hz_Relationships r
1527: WHERE obj.party_id = p_customer_id
1528: AND sub.status = 'A'
1529: AND sub.party_type IN ('PERSON','ORGANIZATION')
1530: AND p.party_id = r.party_id