DBA Data[Home] [Help]

APPS.PORCPTWF dependencies on PO_DISTRIBUTIONS_ALL

Line 3673: -- Update the PO_DISTRIBUTIONS_ALL table with this

3669: itemtype => itemtype,
3670: itemkey => itemkey,
3671: aname => 'WF_ITEM_KEY');
3672:
3673: -- Update the PO_DISTRIBUTIONS_ALL table with this
3674: -- item key value and qty invoiced value
3675: UPDATE PO_DISTRIBUTIONS_ALL
3676: SET WF_ITEM_KEY = conf_item_key,
3677: invoiced_val_in_ntfn = x_qty_inv

Line 3675: UPDATE PO_DISTRIBUTIONS_ALL

3671: aname => 'WF_ITEM_KEY');
3672:
3673: -- Update the PO_DISTRIBUTIONS_ALL table with this
3674: -- item key value and qty invoiced value
3675: UPDATE PO_DISTRIBUTIONS_ALL
3676: SET WF_ITEM_KEY = conf_item_key,
3677: invoiced_val_in_ntfn = x_qty_inv
3678: WHERE po_distribution_id = x_dist_id;
3679: end if;