DBA Data[Home] [Help]

APPS.INV_STATUS_LOVS SQL Statements

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

Line: 20

      SELECT status_code, status_id
      FROM mtl_material_statuses_vl
      WHERE zone_control = 1
        and enabled_flag = 1
        and status_code like (p_status_code)
      order by status_code;
Line: 33

      SELECT status_code, status_id
      FROM mtl_material_statuses_vl
      WHERE locator_control = 1
        and enabled_flag = 1
        and status_code like (p_status_code)
      order by status_code;
Line: 46

      SELECT status_code, status_id
      FROM mtl_material_statuses_vl
      WHERE lot_control = 1
        and enabled_flag = 1
        and status_code like (p_status_code)
      order by status_code;
Line: 59

      SELECT status_code, status_id
      FROM mtl_material_statuses_vl
      WHERE serial_control = 1
        and enabled_flag = 1
        and status_code like (p_status_code)
      order by status_code;
Line: 73

      SELECT status_code, status_id
      FROM mtl_material_statuses_vl
      WHERE onhand_control = 1
        and enabled_flag = 1
        and status_code like (p_status_code)
      order by status_code;
Line: 94

                     SELECT default_status_id
                     INTO   l_org_default_status_id
                     FROM mtl_parameters
                     WHERE organization_id = p_organization_id;
Line: 106

        SELECT mms.status_code, mms.status_id
        FROM mtl_material_statuses_vl mms
        WHERE mms.onhand_control = 1
          and mms.enabled_flag = 1
          and mms.status_code like (p_status_code)
          and not exists ( select 1 from mtl_status_transaction_control mstc
                           where mms.status_id = mstc.status_id
                           and mstc.is_allowed = 2
                           and mstc.transaction_type_id = p_trx_type_id )
         order by mms.status_code;
Line: 119

        SELECT mms.status_code, mms.status_id
        FROM mtl_material_statuses_vl mms
        WHERE mms.onhand_control = 1
        and mms.enabled_flag = 1
        and mms.status_code like (p_status_code)
        order by mms.status_code;
Line: 128

        SELECT mms.status_code, mms.status_id
        FROM mtl_material_statuses_vl mms
        WHERE mms.lot_control = 1
        and mms.enabled_flag = 1
        and mms.status_code like (p_status_code)
        and not exists ( select 1 from mtl_status_transaction_control mstc
                           where mms.status_id = mstc.status_id
                           and mstc.is_allowed = 2
                           and mstc.transaction_type_id = p_trx_type_id )
        order by mms.status_code;
Line: 141

        SELECT status_code, status_id
        FROM mtl_material_statuses_vl
        WHERE lot_control = 1
          and enabled_flag = 1
          and status_code like (p_status_code)
        order by status_code;
Line: 161

        SELECT mms.status_code, mms.status_id
        FROM mtl_material_statuses_vl mms
        WHERE mms.serial_control = 1
          and mms.enabled_flag = 1
          and mms.status_code like (p_status_code)
          and not exists ( select 1 from mtl_status_transaction_control mstc
                           where mms.status_id = mstc.status_id
                           and mstc.is_allowed = 2
                           and mstc.transaction_type_id = p_trx_type_id )
        order by mms.status_code;
Line: 173

        SELECT status_code, status_id
        FROM mtl_material_statuses_vl
        WHERE serial_control = 1
          and enabled_flag = 1
          and status_code like (p_status_code)
        order by status_code;