APPS.INV_PROJECT SQL Statements

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

Line: 104

   /*  SELECT m.segment1
  INTO source_project_number
  FROM pa_projects_all m
  WHERE m.project_id = source_project_id ; */

Line: 109

 SELECT m.project_number
  INTO source_project_number
  FROM pjm_projects_all_v m
  WHERE m.project_id = source_project_id ;

Line: 127

   /* SELECT my.segment1
  INTO p_project_number
  FROM pa_projects_all  my
  WHERE my.project_id = p_project_id ; */

Line: 132

  SELECT my.project_number
  INTO p_project_number
  FROM pjm_projects_all_v my
  WHERE my.project_id = p_project_id ;

Line: 150

  /*   SELECT m.segment1
  INTO to_project_number
  FROM pa_projects_all m
  WHERE m.project_id = to_project_id ; */

Line: 155

  SELECT m.project_number
  INTO to_project_number
  FROM pjm_projects_all_v m
  WHERE m.project_id = to_project_id ;

Line: 170

  SELECT m.task_number
  INTO source_task_number
  FROM pjm_tasks_v m
  WHERE m.task_id = source_task_id
  AND   m.project_id = source_project_id;

Line: 187

  SELECT m.task_number
  INTO t_task_number
  FROM pjm_tasks_v m
  WHERE m.task_id = t_task_id
  AND   m.project_id = p_project_id;

Line: 203

  SELECT m.task_number
  INTO to_task_number
  FROM pjm_tasks_v m
  WHERE m.task_id = to_task_id
  AND   m.project_id = to_project_id;

Line: 221

      SELECT m.name
      INTO pa_expenditure_org
      FROM pa_organizations_expend_v  m
      WHERE m.organization_id = pa_expenditure_org_id
      AND   active_flag='Y'
      AND ROWNUM = 1;

Line: 252

  SELECT NVL(mp.project_reference_enabled, 2),
	 NVL(mp.pm_cost_collection_enabled,2),
	 NVL(mp.project_control_level,1)
  INTO   p_project_reference_enabled,
	 p_pm_cost_collection_enabled,
	 p_project_control_level
  FROM   mtl_parameters mp
  WHERE  organization_id = org_id ;

Line: 278

  SELECT NVL(SUM(primary_transaction_quantity),0)
  INTO qty_found
  FROM MTL_ONHAND_QUANTITIES_DETAIL
  WHERE organization_id = org_id
  AND subinventory_code = NVL(sub_code, subinventory_code)
  AND NVL(locator_id,-9999) = NVL(loc_id, NVL(locator_id,-9999)) ;

Line: 305

  SELECT COUNT(transaction_temp_id)
  INTO trx_found
  FROM mtl_material_transactions_temp
  WHERE organization_id = org_id
  AND subinventory_code = NVL(sub_code, subinventory_code)
  AND NVL(locator_id,-9999) = NVL(loc_id, NVL(locator_id,-9999)) ;

Line: 335

  SELECT COUNT(transaction_interface_id)
  INTO trx_found
  FROM mtl_transactions_interface
  WHERE organization_id = org_id
  AND subinventory_code = NVL(sub_code, subinventory_code)
  AND NVL(locator_id,-9999) = NVL(loc_id, NVL(locator_id,-9999)) ;

Line: 423

   id is the req_line_id. The project and task is selected from po_requisition_lines
   table.
*/
	prj_ref_enabled number ;

Line: 447

  SELECT NVL(project_reference_enabled,2), NVL(project_control_level,1)
  INTO prj_ref_enabled, prj_cntrl_level
  FROM mtl_parameters
  WHERE organization_id = fm_org_id ;

Line: 465

    SELECT project_id
    INTO f_project_id
    FROM mtl_item_locations
    WHERE inventory_location_id = fm_locator
    AND organization_id = fm_org_id ;

Line: 475

        SELECT task_id
        INTO f_task_id
        FROM mtl_item_locations
        WHERE NVL(project_id,-999) = NVL(f_project_id, -111)
        AND inventory_location_id = fm_locator
        AND organization_id = fm_org_id ;

Line: 490

      SELECT project_id
      INTO t_project_id
      FROM mtl_item_locations
      WHERE inventory_location_id = to_locator
      AND organization_id = fm_org_id ;

Line: 500

      SELECT task_id
      INTO t_task_id
      FROM mtl_item_locations
      WHERE inventory_location_id = to_locator
      AND organization_id = fm_org_id ;

Line: 517

  SELECT NVL(project_reference_enabled,2), NVL(project_control_level,1)
  INTO to_org_prj_ref_enabled, to_org_prj_cntrl_level
  FROM mtl_parameters
  WHERE organization_id = to_org_id ;

Line: 569

         SELECT project_id
         INTO t_project_id
         FROM mtl_item_locations
         WHERE inventory_location_id = to_locator
         AND organization_id = to_org_id ;

Line: 580

      SELECT task_id
      INTO t_task_id
      FROM mtl_item_locations
      WHERE inventory_location_id = to_locator
      AND organization_id = to_org_id ;

Line: 683

SELECT NVL(project_control_level,1)
INTO x_fm_org_project_control_level
FROM mtl_parameters
WHERE organization_id = v_org_id ;

Line: 689

  SELECT NVL(project_control_level,1)
  INTO x_to_org_project_control_level
  FROM mtl_parameters
  WHERE organization_id = v_xfr_org_id ;

Line: 761

Procedure update_project_task(v_org_id	       number,
                              v_in_project_id  number,
                              v_in_task_id     number,
                              v_out_project_id in out NOCOPY number,
                              v_out_task_id    in out NOCOPY number) is
  v_project_reference_enabled  number;

Line: 787

end update_project_task;

Line: 788

Procedure update_project_task_number(v_org_id	       number,
                                     v_in_project_id   number,
                                     v_in_task_id      number,
                                     v_out_project_id  in out NOCOPY number,
                                     v_out_task_id     in out NOCOPY number,
                                     v_out_project     in out NOCOPY varchar2,
                                     v_out_task        in out NOCOPY varchar2) is
  v_project_reference_enabled  number;

Line: 817

         select project_number
         into v_out_project
         from mtl_project_v
         where project_id = v_in_project_id;

Line: 829

         select task_number
         into v_out_task
         from mtl_task_v
         where project_id = v_in_project_id
         and   task_id = v_in_task_id;

Line: 841

end update_project_task_number;

Line: 866

        SELECT project_id,task_id
        INTO   l_req_project_id,l_req_task_id
        FROM   po_req_distributions_all
        WHERE  requisition_line_id = p_req_line_id;

Line: 904

        SELECT prd.project_id, prd.task_id
        INTO   l_req_project_id,l_req_task_id
        FROM   po_req_distributions_all prd,
               rcv_transactions rcv
        WHERE  rcv.transaction_id = P_Rcv_Trx_Id
        And    prd.requisition_line_id = rcv.requisition_line_id;

Line: 1003

        SELECT operating_unit
        INTO   l_org_id
        FROM org_organization_definitions
        WHERE organization_id = P_Organization_Id;

Line: 1098

  SELECT mil.segment19, mil.segment20
  INTO   l_project_id, l_task_id
  FROM   mtl_item_locations mil, wms_license_plate_numbers wlpn
  WHERE  wlpn.lpn_id = p_lpn_id
  AND    wlpn.organization_id = p_organization_id
  AND    wlpn.organization_id = mil.organization_id
  AND    wlpn.locator_id     = mil.inventory_location_id;

Line: 1112

         select DISTINCT project_id, task_id
         INTO   l_project_id, l_task_id
         FROM   mtl_txn_request_lines
         WHERE  organization_id = p_organization_id
         AND    lpn_id          = p_lpn_id;

Line: 1175

  SELECT NVL(project_reference_enabled,2)
  INTO   l_project_reference_enabled
  FROM   mtl_parameters
  WHERE  organization_id = p_org_id ;

Line: 1223

   SELECT APPLICATION_COLUMN_NAME,
          ffs.FLEX_VALUE_SET_ID,
          ffv.VALIDATION_TYPE
   FROM   FND_ID_FLEX_SEGMENTS ffs,
          FND_FLEX_VALUE_SETS ffv
   WHERE  APPLICATION_ID = 401 -- 'INV'
   AND    ID_FLEX_CODE = 'MTLL'
   AND    ID_FLEX_NUM  = 101 -- 'STOCK_LOCATORS'
   AND    ENABLED_FLAG = 'Y'
   AND    DISPLAY_FLAG = 'Y'
   AND    ffv.FLEX_VALUE_SET_ID(+) = ffs.FLEX_VALUE_SET_ID
   ORDER BY SEGMENT_NUM;

Line: 1265

            SELECT CONCATENATED_SEGMENT_DELIMITER
            INTO L_DELIM
            FROM FND_ID_FLEX_STRUCTURES
            WHERE ID_FLEX_CODE = 'MTLL' AND ROWNUM =1;

Line: 1420

     l_loc_str := 'SELECT ' || G_CONCATENATED_SEGMENTS || ', ';

Line: 1473

                               SELECT_COMB_FROM_VIEW => NULL
                                                 );

Line: 1550

   /*SELECT PROJECT_NUMBER
   INTO   L_PROJECT_NUMBER
   FROM   PJM_PROJECTS_MTLL_V
   WHERE  PROJECT_ID = P_PROJECT_ID;

Line: 1568

  /* SELECT TASK_NUMBER
   INTO   L_TASK_NUMBER
   FROM   PJM_TASKS_MTLL_V
   WHERE  TASK_ID = P_TASK_ID;

Line: 1591

 * combination. They are for use in select statements e.g.
 *        SELECT ..
 *               ..
 *               INV_PROJECT.GET_LOCSEGS(LOCATOR_ID,ORG_ID)
 *               INV_PROJECT.GET_PROJECT_ID,
 *               INV_PROJECT.GET_PROJECT_NUMBER,
 *               INV_PROJECT.GET_TASK_ID,
 *               INV_PROJECT.GET_TASK_NUMBER,
 *               ..
 *        FROM   WMS_LICENSE_PLATE_NUMBERS
 *
 */
FUNCTION GET_PROJECT_NUMBER RETURN VARCHAR2 IS
BEGIN
  RETURN G_PROJECT_NUMBER;

Line: 1639

   SELECT APPLICATION_COLUMN_NAME,
          ffs.FLEX_VALUE_SET_ID,
          ffv.VALIDATION_TYPE
   FROM   FND_ID_FLEX_SEGMENTS ffs,
          FND_FLEX_VALUE_SETS ffv
   WHERE  APPLICATION_ID = 401 -- 'INV'
   AND    ID_FLEX_CODE = 'MTLL'
   AND    ID_FLEX_NUM  = 101 -- 'STOCK_LOCATORS'
   AND    ENABLED_FLAG = 'Y'
   AND    DISPLAY_FLAG = 'Y'
   AND    ffv.FLEX_VALUE_SET_ID(+) = ffs.FLEX_VALUE_SET_ID
   ORDER BY SEGMENT_NUM;

Line: 1664

     SELECT CONCATENATED_SEGMENT_DELIMITER
     INTO L_DELIM
     FROM FND_ID_FLEX_STRUCTURES
     WHERE ID_FLEX_CODE = 'MTLL' AND ROWNUM =1;

Line: 1778

     l_loc_str := 'SELECT ' || G_LOC_CONC_QRY ;

Line: 1810

                               SELECT_COMB_FROM_VIEW => NULL
                                                 );

Line: 1839

      SELECT application_column_name
       FROM fnd_id_flex_segments ffs
      WHERE application_id = 401 -- 'INV'
        AND id_flex_code = 'MTLL'
        AND id_flex_num = 101    -- 'STOCK_LOCATORS'
        AND enabled_flag = 'Y'
        AND display_flag = 'Y'
       ORDER BY segment_num;

Line: 1849

      SELECT concatenated_segment_delimiter
        FROM fnd_id_flex_structures
       WHERE id_flex_code = 'MTLL'
         AND ROWNUM = 1;

Line: 1933

      SELECT application_column_name
       FROM fnd_id_flex_segments ffs
      WHERE application_id = 401 -- 'INV'
        AND id_flex_code = 'MTLL'
        AND id_flex_num = 101    -- 'STOCK_LOCATORS'
        AND enabled_flag = 'Y'
        AND display_flag = 'Y'
       ORDER BY segment_num;

Line: 1943

      SELECT concatenated_segment_delimiter
        FROM fnd_id_flex_structures
       WHERE id_flex_code = 'MTLL'
         AND ROWNUM = 1;

Line: 2018

            SELECT m.project_number
	      INTO l_pt_buf
	      FROM pjm_projects_all_v m
              WHERE m.project_id = l_project_id
              AND ROWNUM = 1;

Line: 2029

            SELECT m.task_number
	    INTO l_pt_buf
	    FROM pjm_tasks_v m
	    WHERE m.task_id = l_task_id
	      AND   m.project_id = l_project_id
              AND ROWNUM = 1;