DBA Data[Home] [Help]

APPS.PO_DOCUMENT_UPDATE_PVT dependencies on OE_DROP_SHIP_SOURCES

Line 6057: oe_drop_ship_sources oedp

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
6059: AND oedp.line_location_id = l_line_location_id
6060: AND oedp.line_id = oel.line_id -- JOIN
6061: AND oel.sold_to_org_id = cu.party_id -- JOIN

Line 6078: oe_drop_ship_sources oedp

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
6081: AND site.site_use_code = 'SHIP_TO'
6082: AND site.cust_acct_site_id = acct_site.cust_acct_site_id

Line 6101: oe_drop_ship_sources oedp,

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
6104: AND loc.location_id = l_new_ship_to_loc_id
6105: AND site.site_use_code = 'SHIP_TO'