DBA Data[Home] [Help]

APPS.RCV_SHIPMENT_LINES_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 378: UPDATE po_line_locations_all poll

374: debug_log(FND_LOG.LEVEL_STATEMENT,l_api_name,
375: 'l_amt_shipped ' ||l_amt_shipped);
376: end if;
377:
378: UPDATE po_line_locations_all poll
379: set poll.quantity_shipped = nvl(poll.quantity_shipped,0) +
380: l_qty_shipped,
381: poll.amount_shipped = nvl(poll.amount_shipped,0) +
382: l_amt_shipped,

Line 544: po_line_locations_all pll,

540: pd.destination_organization_id,
541: pd.destination_subinventory,
542: 'Y'
543: from po_distributions_all pd,
544: po_line_locations_all pll,
545: po_lines_all pl
546: where pd.po_distribution_id = dist_info.po_distribution_id
547: and pll.line_location_id = pd.line_location_id
548: and pl.po_line_id = pd.po_line_id