1418: prd.gl_encumbered_period_name,
1419: Nvl(prd.prevent_encumbrance_flag,'N'),
1420: prl.blanket_po_header_id
1421: FROM
1422: po_requisition_lines_all prl,
1423: po_req_distributions_all prd
1424: WHERE
1425: NVL(prl.closed_code, 'X') NOT IN ('CANCELLED','FINALLY CLOSED')
1426: AND NVL(prl.cancel_flag, 'N') = 'N'