DBA Data[Home] [Help]

APPS.RCV_BILL_UPDATING_SV dependencies on PO_LINE_LOCATIONS_ALL

Line 140: UPDATE po_line_locations_all pll

136: /* Bug 4305628: For Planned Purchase orders, the quantity/amount billed on the
137: ** Scheduled Release (SR) as well as the backing order (PPO)
138: ** should be updated.
139: */
140: UPDATE po_line_locations_all pll
141: SET pll.quantity_billed = nvl(pll.quantity_billed,0) + X_po_quantity_billed,
142: pll.amount_billed = nvl(pll.amount_billed,0) + X_po_amount_billed
143: WHERE pll.line_location_id = X_po_line_location_id
144: OR ( pll.shipment_type = 'PLANNED'