DBA Data[Home] [Help]

APPS.RCV_BILL_UPDATING_SV dependencies on PO_DISTRIBUTIONS_ALL

Line 62: UPDATE po_distributions_all pod

58: /* Bug 4305628: For Planned Purchase orders, the quantity/amount billed on the
59: ** Scheduled Release (SR) as well as the backing order (PPO)
60: ** should be updated.
61: */
62: UPDATE po_distributions_all pod
63: SET pod.quantity_billed = nvl(pod.quantity_billed,0) + X_po_quantity_billed,
64: pod.amount_billed = nvl(pod.amount_billed,0) + X_po_amount_billed
65: WHERE po_distribution_id = X_po_distribution_id
66: OR ( pod.distribution_type = 'PLANNED'