APPS.IEX_STRATEGY_CNT_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 114: ' From hz_cust_acct_sites_all acct_sites, ' ||

110: BEGIN
111: --if l_StrategyLevelName <> 'DELINQUENCY' then
112: if p_strategy_level <> 40 then
113: l_custom_select := ' SELECT p.party_name ' ||
114: ' From hz_cust_acct_sites_all acct_sites, ' ||
115: ' hz_party_sites party_site, ' ||
116: ' hz_cust_accounts ca, ' ||
117: ' hz_cust_site_uses_all site_uses, ' ||
118: ' hz_parties p ' ||

Line 126: ' From hz_cust_acct_sites_all acct_sites, ' ||

122: ' AND site_uses.site_use_code = ''BILL_TO'' ' ||
123: ' AND ca.party_id = p.party_id ';
124: else
125: l_custom_select := 'SELECT p.party_name ' ||
126: ' From hz_cust_acct_sites_all acct_sites, ' ||
127: ' hz_party_sites party_site, ' ||
128: ' hz_cust_accounts ca, ' ||
129: ' hz_cust_site_uses_all site_uses, ' ||
130: ' hz_parties p,' ||

Line 3061: hz_cust_acct_sites_all cas,

3057: and st.org_id is null
3058: and st.object_id=hp.party_id
3059: and not exists(select 1 from
3060: hz_cust_accounts ca,
3061: hz_cust_acct_sites_all cas,
3062: hz_cust_site_uses_all su
3063: where hp.party_id = ca.party_id
3064: and ca.cust_account_id=cas.cust_account_id
3065: and cas.cust_acct_site_id=su.cust_acct_site_id

Line 3077: hz_cust_acct_sites_all cas,

3073: where st.object_type='ACCOUNT'
3074: and st.org_id is null
3075: and st.object_id=ca.cust_account_id
3076: and not exists(select 1 from
3077: hz_cust_acct_sites_all cas,
3078: hz_cust_site_uses_all su
3079: where ca.cust_account_id=cas.cust_account_id
3080: and cas.cust_acct_site_id=su.cust_acct_site_id
3081: and su.org_id <> p_org_id);

Line 3692: hz_cust_acct_sites_all acct_sites,

3688: c.account_number,
3689: site_uses.location
3690: from hz_parties p,
3691: hz_cust_accounts c,
3692: hz_cust_acct_sites_all acct_sites,
3693: hz_cust_site_uses_all site_uses
3694: where site_uses.site_use_id = p_cust_site_use_id
3695: and acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id
3696: and c.cust_account_id = acct_sites.cust_account_id