6049: /* SELECT count(*)
6050: INTO l_ship_to_loc_valid
6051: FROM hz_locations hz,
6052: hz_party_sites ps,
6053: hz_cust_site_uses_all su,
6054: hz_cust_acct_sites_all asa,
6055: hz_cust_accounts cu,
6056: oe_order_lines_all oel,
6057: oe_drop_ship_sources oedp
6069: -- after recommendationsfrom OM
6070:
6071: SELECT count(*)
6072: into l_ship_to_loc_valid
6073: FROM hz_cust_site_uses_all site,
6074: hz_party_sites party_site,
6075: hz_locations loc,
6076: hz_cust_acct_sites_all acct_site ,
6077: oe_order_lines_all oel,
6092: so that this sql cares for across OU validation of ship to location for related customer */
6093: IF (l_ship_to_loc_valid = 0) THEN
6094: SELECT Count(*)
6095: INTO l_ship_to_loc_valid
6096: FROM hz_cust_site_uses_all site,
6097: hz_party_sites party_site,
6098: hz_locations loc,
6099: hz_cust_acct_sites_all acct_site ,
6100: oe_order_lines_all oel,