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.QP_UTIL_PUB dependencies on HZ_CUST_ACCT_RELATE

Line 1116: hz_cust_acct_relate r

1112: oa.sold_to_org_id IS NULL OR
1113: oa.sold_to_org_id = -1 OR
1114: oa.sold_to_org_id IN (
1115: SELECT r.cust_account_id FROM
1116: hz_cust_acct_relate r
1117: WHERE r.related_cust_account_id = l_sold_to_org_id AND
1118: r.status = 'A' AND l_cust_relation_flag = 'Y'))
1119: AND qlhv.source_system_code IN (SELECT qpss.application_short_name
1120: FROM qp_pte_source_systems qpss

Line 1270: hz_cust_acct_relate r

1266: oa.sold_to_org_id IS NULL OR
1267: oa.sold_to_org_id = -1 OR
1268: oa.sold_to_org_id IN (
1269: SELECT r.cust_account_id FROM
1270: hz_cust_acct_relate r
1271: WHERE r.related_cust_account_id = l_sold_to_org_id AND
1272: r.status = 'A' AND l_cust_relation_flag = 'Y'))
1273: AND qlhv.source_system_code IN (SELECT qpss.application_short_name
1274: FROM qp_pte_source_systems qpss

Line 1543: SELECT r.cust_account_id FROM hz_cust_acct_relate r

1539: SELECT TO_NUMBER(p_sold_to_org_id) FROM dual
1540: UNION
1541: SELECT -1 FROM dual
1542: UNION
1543: SELECT r.cust_account_id FROM hz_cust_acct_relate r
1544: WHERE r.related_cust_account_id = p_sold_to_org_id AND
1545: l_cust_relation_flag = 'Y' AND
1546: r.status = 'A' ) AND
1547: l_temp_date BETWEEN

Line 1602: select r.cust_account_id from hz_cust_acct_relate r

1598: select to_number(p_sold_to_org_id) from dual
1599: union
1600: select -1 from dual
1601: union
1602: select r.cust_account_id from hz_cust_acct_relate r
1603: where r.related_cust_account_id = p_sold_to_org_id and
1604: l_cust_relation_flag = 'Y' and
1605: r.status = 'A' ) and
1606: l_temp_date between