APPS.PO_DOCUMENT_UPDATE_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 6103: hz_cust_site_uses_all su,

6099: /* SELECT count(*)
6100: INTO l_ship_to_loc_valid
6101: FROM hz_locations hz,
6102: hz_party_sites ps,
6103: hz_cust_site_uses_all su,
6104: hz_cust_acct_sites_all asa,
6105: hz_cust_accounts cu,
6106: oe_order_lines_all oel,
6107: oe_drop_ship_sources oedp

Line 6123: FROM hz_cust_site_uses_all site,

6119: -- after recommendationsfrom OM
6120:
6121: SELECT count(*)
6122: into l_ship_to_loc_valid
6123: FROM hz_cust_site_uses_all site,
6124: hz_party_sites party_site,
6125: hz_locations loc,
6126: hz_cust_acct_sites_all acct_site ,
6127: oe_order_lines_all oel,

Line 6146: FROM hz_cust_site_uses_all site,

6142: so that this sql cares for across OU validation of ship to location for related customer */
6143: IF (l_ship_to_loc_valid = 0) THEN
6144: SELECT Count(*)
6145: INTO l_ship_to_loc_valid
6146: FROM hz_cust_site_uses_all site,
6147: hz_party_sites party_site,
6148: hz_locations loc,
6149: hz_cust_acct_sites_all acct_site ,
6150: oe_order_lines_all oel,