DBA Data[Home] [Help]

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;