DBA Data[Home] [Help]

APPS.PO_REQUISITION_HEADERS_PKG dependencies on PO_REQUISITION_LINES

Line 374: FROM po_requisition_lines

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

Line 419: FROM po_requisition_lines

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