APPS.PJM_INQUIRY dependencies on OE_ORDER_LINES_ALL

Line 307: FROM oe_order_lines_all

303: (NVL(ordered_quantity,0)-NVL(cancelled_quantity,0))
304: )
305: * NVL(unit_selling_price , 0) )
306: INTO L_Order_Total
307: FROM oe_order_lines_all
308: WHERE header_id = X_Header_ID
309: AND project_id = NVL(x_project_id, project_id)
310: AND (task_id IS NULL OR task_id = NVL(x_task_id, task_id)) --Bug 13455756: still need to return value even if task_id column is null
311: AND line_id = x_line_id;