DBA Data[Home] [Help]

APPS.PO_AUTOCREATE_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1203: FROM po_req_distributions_all prd, po_requisition_lines_all prl

1199: --Update req_distribution_id in po_requisition_lines_all after mod creation
1200: BEGIN
1201: SELECT distribution_id, par_distribution_id
1202: BULK COLLECT INTO l_distribution_id_tbl, l_par_distribution_id_tbl
1203: FROM po_req_distributions_all prd, po_requisition_lines_all prl
1204: WHERE prl.par_line_id = p_par_line_tbl(i)
1205: AND prl.par_draft_id = p_par_draft_id_tbl(i)
1206: AND prd.par_draft_id = prl.par_draft_id
1207: AND prl.requisition_line_id = prd.requisition_line_id;