APPS.QP_UTIL_PUB dependencies on HZ_CUST_ACCT_RELATE

Line 1446: hz_cust_acct_relate r

1442: oa.sold_to_org_id IS NULL OR
1443: oa.sold_to_org_id = -1 OR
1444: oa.sold_to_org_id IN (
1445: SELECT r.cust_account_id FROM
1446: hz_cust_acct_relate r
1447: WHERE r.related_cust_account_id = l_sold_to_org_id AND
1448: r.status = 'A' AND l_cust_relation_flag = 'Y'))
1449: AND qlhv.source_system_code IN (SELECT qpss.application_short_name
1450: FROM qp_pte_source_systems qpss

Line 1600: hz_cust_acct_relate r

1596: oa.sold_to_org_id IS NULL OR
1597: oa.sold_to_org_id = -1 OR
1598: oa.sold_to_org_id IN (
1599: SELECT r.cust_account_id FROM
1600: hz_cust_acct_relate r
1601: WHERE r.related_cust_account_id = l_sold_to_org_id AND
1602: r.status = 'A' AND l_cust_relation_flag = 'Y'))
1603: AND qlhv.source_system_code IN (SELECT qpss.application_short_name
1604: FROM qp_pte_source_systems qpss

Line 1873: SELECT r.cust_account_id FROM hz_cust_acct_relate r

1869: SELECT TO_NUMBER(p_sold_to_org_id) FROM dual
1870: UNION
1871: SELECT -1 FROM dual
1872: UNION
1873: SELECT r.cust_account_id FROM hz_cust_acct_relate r
1874: WHERE r.related_cust_account_id = p_sold_to_org_id AND
1875: l_cust_relation_flag = 'Y' AND
1876: r.status = 'A' ) AND
1877: l_temp_date BETWEEN

Line 1932: select r.cust_account_id from hz_cust_acct_relate r

1928: select to_number(p_sold_to_org_id) from dual
1929: union
1930: select -1 from dual
1931: union
1932: select r.cust_account_id from hz_cust_acct_relate r
1933: where r.related_cust_account_id = p_sold_to_org_id and
1934: l_cust_relation_flag = 'Y' and
1935: r.status = 'A' ) and
1936: l_temp_date between