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
6058: WHERE hz.location_id = l_new_ship_to_loc_id
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,
6078: oe_drop_ship_sources oedp
6079: WHERE oedp.line_location_id = l_line_location_id
6080: AND loc.location_id = l_new_ship_to_loc_id
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,
6101: oe_drop_ship_sources oedp,
6102: hz_cust_acct_relate_all rel
6103: WHERE oedp.line_location_id = l_line_location_id