DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UPDATE_PVT dependencies on HZ_PARTY_SITES

Line 6052: hz_party_sites ps,

6048: -- location, 0 otherwise.
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,

Line 6074: hz_party_sites party_site,

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,
6078: oe_drop_ship_sources oedp

Line 6097: hz_party_sites party_site,

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,
6101: oe_drop_ship_sources oedp,