DBA Data[Home] [Help]

APPS.PJM_INQUIRY dependencies on PO_REQUISITION_LINES_ALL

Line 22: FROM po_requisition_lines_all

18: (quantity * unit_price)
19: )
20: ), 0)
21: into X_req_total
22: FROM po_requisition_lines_all
23: WHERE requisition_header_id = p_header_id and
24: nvl(cancel_flag,'N') <> 'Y' and -- Bug 554452 Ignore cancelled lines
25: nvl(MODIFIED_BY_AGENT_FLAG, 'N') = 'N' and -- Bug 574676
26: nvl(CLOSED_CODE, 'OPEN') <> 'FINALLY CLOSED'; -- Bug 574676