DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UPDATE_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 6054: hz_cust_acct_sites_all asa,

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

Line 6076: hz_cust_acct_sites_all acct_site ,

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

Line 6099: hz_cust_acct_sites_all acct_site ,

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