APPS.INV_MEANING_SEL SQL Statements

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

Line: 8

        select  meaning
        into temp
        from mfg_lookups
        where lookup_code = lookup_code_val
        and lookup_type = lookup_type_val;

Line: 28

        select  unit_of_measure
        into ret_string
        from mtl_units_of_measure
        where uom_code = uom_code_val;

Line: 47

        select  un_number
        into ret_string
        from po_un_numbers_tl
        where un_number_id = un_number_val
        and   language = userenv('LANG');

Line: 67

        select  HAZARD_CLASS
        into ret_string
        from po_hazard_classes_tl
        where hazard_class_id = hazard_val
        and   language = userenv('LANG');

Line: 88

        select  full_name
        into ret_string
        from per_people_f
        where person_id = person_id_val
        and trunc(sysdate) >= effective_start_date(+)
        and trunc(sysdate) <= effective_end_date(+);

Line: 109

        select  meaning
        into temp
        from fnd_lookups
        where lookup_code = lookup_code_val
        and lookup_type = lookup_type_val;

Line: 129

        select  picking_rule_name
        into ret_string
        from mtl_picking_rules
        where picking_rule_id = pick_id_val;

Line: 149

        select  rule_name
        into ret_string
        from mtl_atp_rules
        where rule_id = atp_id_val;

Line: 170

        select name into ret_string
        from   hr_organization_units
        where  organization_id = org_id_val;

Line: 189

        select  name
        into ret_string
        from ra_rules
        where rule_id = rule_id_val;

Line: 208

        select  name
        into ret_string
        from ra_terms
        where term_id = term_id_val;

Line: 227

        select  meaning
        into temp
        from fnd_lookup_values_vl
        where lookup_code = lookup_code_val
        and lookup_type = lookup_type_val;

Line: 248

        select  displayed_field
        into temp
        from po_lookup_codes
        where lookup_code = lookup_code_val
        and lookup_type = lookup_type_val;

Line: 268

        select  meaning
        into temp
        from fnd_lookup_values
        where lookup_code = lookup_code_val
        and lookup_type = lookup_type_val
        and view_application_id = 3
        and language = userenv('LANG');

Line: 290

        select STATUS_CODE
        into temp
        from mtl_material_statuses_vl
        where LOT_CONTROL =1
        and ENABLED_FLAG = 1
        and Status_Id = status_id_val;

Line: 311

        select STATUS_CODE
        into temp
        from mtl_material_statuses_vl
        where SERIAL_CONTROL =1
        and ENABLED_FLAG = 1
        and Status_Id = status_id_val;

Line: 332

        select unit_of_measure
        into temp
        from mtl_units_of_measure_vl
        where uom_code = uom_code_val
        and language = userenv('LANG');

Line: 352

        select meaning
        into temp
        from fnd_common_lookups
        where lookup_code = lookup_code_val
        and  lookup_type = lookup_type_val;

Line: 373

                Select sum(primary_transaction_quantity)
                into   temp
                from   mtl_onhand_quantities_detail
                where  inventory_item_id = Item_Id
                and    organization_id  = Org_Id
                and    subinventory_code = Sub_Code;

Line: 380

                Select sum(primary_transaction_quantity)
                into   temp
                from   mtl_onhand_quantities_detail
                where  inventory_item_id = Item_Id
                and    organization_id  = Org_Id;

Line: 395

        select description
        into temp
        from mtl_system_items_tl
        where INVENTORY_ITEM_ID = Item_Id
        and ORGANIZATION_ID = Org_Id
        and LANGUAGE = userenv('LANG');

Line: 412

        select description
        into temp
        from mtl_item_revisions_tl
        where INVENTORY_ITEM_ID = Item_Id
        and ORGANIZATION_ID = Org_Id
        and REVISION_ID = Rev_Id
        and LANGUAGE = userenv('LANG');

Line: 432

        select  meaning
        into temp
        from oe_lookups
        where lookup_code = lookup_code_val
        and   lookup_type = lookup_type_val;

Line: 452

     SELECT name INTO l_temp
     FROM   OKS_COVERAGE_TEMPLTS_V
     WHERE  ID = COVERAGE_SCHEDULE_ID;

Line: 466

                select  inventory_item_status_code_tl
                into ret_string
                from mtl_item_status
                where inventory_item_status_code = status_code_val;

Line: 487

                select  status_code
                into ret_string
                from MTL_MATERIAL_STATUSES_TL
                where status_id = status_code_val AND language =
userenv('LANG');