APPS.PORCPTWF dependencies on PO_DISTRIBUTIONS

Line 451: PO_DISTRIBUTIONS pod

447: select PORL.auto_receive_flag
448: into x_auto_receive_flag
449: from PO_REQUISITION_LINES PORL,
450: PO_REQ_DISTRIBUTIONS PORD,
451: PO_DISTRIBUTIONS pod
452: where PORD.DISTRIBUTION_ID = POD.REQ_DISTRIBUTION_ID AND
453: PORD.REQUISITION_LINE_ID = PORL.requisition_line_id AND
454: POD.PO_DISTRIBUTION_ID = x_po_distribution_id;
455:

Line 505: update po_distributions

501: -- Clean the po distribtions table
502: -- set the wf_item_key column with null value
503: -- if there are any existing distribtion lines with
504: -- old match.
505: update po_distributions
506: set wf_item_key = ''
507: where po_header_id = x_po_header_ID
508: and wf_item_key like x_po_header_ID||';'||x_requester_id||';%';
509:

Line 1935: update po_distributions

1931: IF x_RCV_txns_rc is NULL OR
1932: x_RCV_txns_rc = 0 THEN
1933:
1934: -- Clean the po distribtions table
1935: update po_distributions
1936: set wf_item_key = ''
1937: where po_header_id = x_po_header_ID
1938: and wf_item_key like x_po_header_ID||';'||x_requester_id||';%';
1939:

Line 2557: po_requisition_lines prl,po_distributions pod,

2553:
2554: select prh.segment1
2555: INTO x_req_number
2556: from po_requisition_headers prh,
2557: po_requisition_lines prl,po_distributions pod,
2558: po_req_distributions pord
2559: where pod.po_distribution_id = x_po_distribution_id and
2560: pord.distribution_id = pod.req_distribution_id and
2561: pord.requisition_line_id = prl.requisition_line_id and

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;

Line 3866: update po_distributions

3862: IF x_RCV_txns_rc is NULL OR x_RCV_txns_rc = 0 THEN
3863: RESULT := 'PASSED';
3864:
3865: -- Clean the po distribtions table
3866: update po_distributions
3867: set wf_item_key = ''
3868: where wf_item_key = itemKey;
3869:
3870: ELSE