APPS.PORCPTWF dependencies on PO_DISTRIBUTIONS

Line 453: PO_DISTRIBUTIONS pod

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

Line 507: update po_distributions

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

Line 1938: update po_distributions

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

Line 2602: po_requisition_lines prl,po_distributions pod,

2598:
2599: select prh.segment1
2600: INTO x_req_number
2601: from po_requisition_headers prh,
2602: po_requisition_lines prl,po_distributions pod,
2603: po_req_distributions pord
2604: where pod.po_distribution_id = x_po_distribution_id and
2605: pord.distribution_id = pod.req_distribution_id and
2606: pord.requisition_line_id = prl.requisition_line_id and

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;

Line 3926: update po_distributions

3922: IF x_RCV_txns_rc is NULL OR x_RCV_txns_rc = 0 THEN
3923: RESULT := 'PASSED';
3924:
3925: -- Clean the po distribtions table
3926: update po_distributions
3927: set wf_item_key = ''
3928: where wf_item_key = itemKey;
3929:
3930: ELSE