APPS.EAM_MATERIAL_REQUEST_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 105

    select project_id, task_id into l_project_id, l_task_id
    from wip_discrete_jobs
    where wip_entity_id = p_wip_entity_id;

Line: 164

    select sum(quantity_detailed) into l_partial_qty
    from mtl_txn_request_lines
    where header_id = (select header_id from mtl_txn_request_headers
      where request_number = x_request_number
      and organization_id = p_organization_id);