DBA Data[Home] [Help]

APPS.IBE_WORKFLOW_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 178: hz_cust_site_uses_all shp_site_use,

174: hz_cust_accounts sold_to_account,
175: hz_locations shipaddr,
176: hz_party_sites shp_party_site,
177: hz_cust_acct_sites_all shp_acct_site,
178: hz_cust_site_uses_all shp_site_use,
179: hz_locations invaddr,
180: hz_party_sites inv_party_site,
181: hz_cust_acct_sites_all inv_acct_site,
182: hz_cust_site_uses_all inv_site_use

Line 182: hz_cust_site_uses_all inv_site_use

178: hz_cust_site_uses_all shp_site_use,
179: hz_locations invaddr,
180: hz_party_sites inv_party_site,
181: hz_cust_acct_sites_all inv_acct_site,
182: hz_cust_site_uses_all inv_site_use
183: where oh.header_id=c_order_id
184: and sold_to_party.party_id= sold_to_account.party_id
185: and sold_to_account.cust_account_id = oh.sold_to_org_id
186: and oh.ship_to_org_id=shp_site_use.site_use_id(+)