1301: pod.quantity_billed,
1302: NVL(pod.encumbered_flag,'N'),
1303: pod.gl_encumbered_date,
1304: pod.gl_encumbered_period_name
1305: FROM po_distributions_all pod,
1306: po_line_locations_all poll,
1307: po_lines_all pol
1308: WHERE DECODE(poll.accrue_on_receipt_flag,
1309: 'N',
1514: pod.unencumbered_quantity,
1515: Nvl(pod.encumbered_flag,'N'),
1516: pod.gl_encumbered_date,
1517: pod.gl_encumbered_period_name
1518: FROM po_distributions_all pod,
1519: po_headers_all poh
1520: WHERE (Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) > 0
1521: AND Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(pod.unencumbered_amount,0)
1522: OR Nvl(pod.encumbered_amount+ pod.unencumbered_amount,0) <> Nvl(poh.blanket_total_amount,0))