APPS.PO_AUTOCREATE_GROUPING_PVT dependencies on PO_REQ_DISTRIBUTIONS_ALL
Line 5036: FROM po_req_distributions_all prd1 WHERE prd1.requisition_line_id = prl.REQUISITION_LINE_ID
5032: FROM po_requisition_lines_all PRL
5033: WHERE
5034: prl.REQUISITION_LINE_ID = p_req_line_id and
5035: nvl(prl.clm_info_flag, 'N') = 'N' AND prl.group_line_id IS NULL AND EXISTS (SELECT 1 5036: FROM po_req_distributions_all prd1 WHERE prd1.requisition_line_id = prl.REQUISITION_LINE_ID 5037: AND prd1.info_line_id IS NOT NULL AND ROWNUM = 1);
5038: EXCEPTION
5039: WHEN No_Data_Found THEN
5040: RETURN l_po_line_num_tbl;