DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on PO_DISTRIBUTIONS_ALL

Line 3725: -- Update the PO_DISTRIBUTIONS_ALL table with this

3721: itemtype => itemtype,
3722: itemkey => itemkey,
3723: aname => 'WF_ITEM_KEY');
3724:
3725: -- Update the PO_DISTRIBUTIONS_ALL table with this
3726: -- item key value and qty invoiced value
3727: UPDATE PO_DISTRIBUTIONS_ALL
3728: SET WF_ITEM_KEY = conf_item_key,
3729: invoiced_val_in_ntfn = x_qty_inv

Line 3727: UPDATE PO_DISTRIBUTIONS_ALL

3723: aname => 'WF_ITEM_KEY');
3724:
3725: -- Update the PO_DISTRIBUTIONS_ALL table with this
3726: -- item key value and qty invoiced value
3727: UPDATE PO_DISTRIBUTIONS_ALL
3728: SET WF_ITEM_KEY = conf_item_key,
3729: invoiced_val_in_ntfn = x_qty_inv
3730: WHERE po_distribution_id = x_dist_id;
3731: end if;