DBA Data[Home] [Help]

APPS.IEX_STRATEGY_DIAG_REPORT dependencies on HZ_CUST_ACCOUNTS

Line 372: hz_cust_accounts c

368: select
369: p.party_name,
370: c.account_number
371: from hz_parties p,
372: hz_cust_accounts c
373: where c.cust_account_id = p_cust_acct_id
374: and c.party_id = p.party_id;
375:
376: cursor c_billto (p_cust_site_use_id number)

Line 383: hz_cust_accounts c,

379: p.party_name,
380: c.account_number,
381: site_uses.location
382: from hz_parties p,
383: hz_cust_accounts c,
384: hz_cust_acct_sites_all acct_sites,
385: hz_cust_site_uses_all site_uses
386: where site_uses.site_use_id = p_cust_site_use_id
387: and acct_sites.cust_acct_site_id = site_uses.cust_acct_site_id

Line 881: hz_parties hzp, hz_cust_accounts acct, iex_dunnings dunn ,

877: dunn.delivery_status,
878: stytm.strategy_name strategy_name,
879: stry_temp_wkitem.name workitem_name
880: from iex_strategies iexst, iex_strategy_work_items wi,
881: hz_parties hzp, hz_cust_accounts acct, iex_dunnings dunn ,
882: iex_strategy_templates_vl stytm,
883: iex_stry_temp_work_items_vl stry_temp_wkitem
884: where wi.last_update_date>(sysdate-1)
885: and wi.strategy_id = iexst.strategy_id