370: (quantity * unit_price)
371: )
372: ), 0)
373: into X_req_total
374: FROM po_requisition_lines
375: WHERE requisition_header_id = p_header_id and
376: nvl(cancel_flag,'N') <> 'Y' and -- Bug 554452 Ignore cancelled lines
377: nvl(MODIFIED_BY_AGENT_FLAG, 'N') = 'N' and -- Bug 574676
378: nvl(CLOSED_CODE, 'OPEN') <> 'FINALLY CLOSED'; -- Bug 574676
415: , 0
416: )
417: --
418: into X_req_total
419: FROM po_requisition_lines
420: WHERE requisition_header_id = p_header_id and
421: nvl(cancel_flag,'N') <> 'Y' and -- Bug 554452 Ignore cancelled lines
422: nvl(MODIFIED_BY_AGENT_FLAG, 'N') = 'N' and -- Bug 574676
423: nvl(CLOSED_CODE, 'OPEN') <> 'FINALLY CLOSED'; -- Bug 574676