DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 168: hz_cust_site_uses_all shp_site_use,

164: hz_cust_accounts sold_to_account,
165: hz_locations shipaddr,
166: hz_party_sites shp_party_site,
167: hz_cust_acct_sites_all shp_acct_site,
168: hz_cust_site_uses_all shp_site_use,
169: hz_locations invaddr,
170: hz_party_sites inv_party_site,
171: hz_cust_acct_sites_all inv_acct_site,
172: hz_cust_site_uses_all inv_site_use

Line 172: hz_cust_site_uses_all inv_site_use

168: hz_cust_site_uses_all shp_site_use,
169: hz_locations invaddr,
170: hz_party_sites inv_party_site,
171: hz_cust_acct_sites_all inv_acct_site,
172: hz_cust_site_uses_all inv_site_use
173: where oh.header_id=c_order_id
174: and sold_to_party.party_id= sold_to_account.party_id
175: and sold_to_account.cust_account_id = oh.sold_to_org_id
176: and oh.ship_to_org_id=shp_site_use.site_use_id(+)