APPS.IEX_STRATEGY_CNT_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 117: ' hz_cust_site_uses_all site_uses, ' ||

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 ' ||
119: ' WHERE acct_sites.cust_account_id = ca.cust_account_id ' ||
120: ' AND acct_sites.party_site_id = party_site.party_site_id ' ||
121: ' AND acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id ' ||

Line 129: ' hz_cust_site_uses_all site_uses, ' ||

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,' ||
131: ' iex_delinquencies_all del ' ||
132: ' WHERE acct_sites.cust_account_id = ca.cust_account_id ' ||
133: ' AND acct_sites.party_site_id = party_site.party_site_id ' ||

Line 3046: hz_cust_site_uses_all su

3042: ) IS
3043: cursor c_bill_strat_wo_ou(p_org_id number)
3044: is select st.strategy_id,su.org_id
3045: from iex_strategies st,
3046: hz_cust_site_uses_all su
3047: where st.object_type='BILL_TO'
3048: and st.org_id is null
3049: and st.object_id=su.site_use_id
3050: and su.org_id = p_org_id;

Line 3062: hz_cust_site_uses_all su

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
3066: and su.org_id <> p_org_id)

Line 3078: hz_cust_site_uses_all su

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);
3082:

Line 3693: hz_cust_site_uses_all site_uses

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
3697: and p.party_id = c.party_id;

Line 3713: hz_cust_site_uses_all c

3709: ar_payment_schedules_all aps ,
3710: hz_parties p,
3711: iex_strategies a,
3712: hz_cust_accounts b,
3713: hz_cust_site_uses_all c
3714: where del.delinquency_id = p_delinquency_id
3715: and del.payment_Schedule_id = aps.payment_Schedule_id
3716: and del.party_cust_id = p.party_id
3717: and del.delinquency_id = a.delinquency_id