DBA Data[Home] [Help]

APPS.IEX_STRATEGY_CNT_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 1719: hz_cust_site_uses_all su

1715: ) IS
1716: cursor c_bill_strat_wo_ou(p_org_id number)
1717: is select st.strategy_id,su.org_id
1718: from iex_strategies st,
1719: hz_cust_site_uses_all su
1720: where st.object_type='BILL_TO'
1721: and st.org_id is null
1722: and st.object_id=su.site_use_id
1723: and su.org_id = p_org_id;

Line 1735: hz_cust_site_uses_all su

1731: and st.object_id=hp.party_id
1732: and not exists(select 1 from
1733: hz_cust_accounts ca,
1734: hz_cust_acct_sites_all cas,
1735: hz_cust_site_uses_all su
1736: where hp.party_id = ca.party_id
1737: and ca.cust_account_id=cas.cust_account_id
1738: and cas.cust_acct_site_id=su.cust_acct_site_id
1739: and su.org_id <> p_org_id)

Line 1751: hz_cust_site_uses_all su

1747: and st.org_id is null
1748: and st.object_id=ca.cust_account_id
1749: and not exists(select 1 from
1750: hz_cust_acct_sites_all cas,
1751: hz_cust_site_uses_all su
1752: where ca.cust_account_id=cas.cust_account_id
1753: and cas.cust_acct_site_id=su.cust_acct_site_id
1754: and su.org_id <> p_org_id);
1755: