APPS.WMA_SPECIAL_LOVS SQL Statements

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

Line: 17

    select restrict_subinventories_code
      into restrictSubinv
    from mtl_system_items
    where organization_id = orgID
      and inventory_item_id = itemID;

Line: 26

        select secondary_inventory_name,
               locator_type
        from   mtl_secondary_inventories
        where  organization_id = orgID
        and    secondary_inventory_name like invName || '%'
        and    secondary_inventory_name <> 'AX_INTRANS'
	and    inv_material_status_grp.is_status_applicable(
                           NULL, -- p_wms_installed,
                           NULL,
                           trxTypeID, -- p_trx_type_id (is this same as trx_type_id?)
                           NULL,
                           NULL,
                           orgID,
                           itemID,
                           secondary_inventory_name,
                           NULL,
                           NULL,
                           NULL,
                           'Z') = 'Y'
        order by secondary_inventory_name;

Line: 49

        select misi.secondary_inventory,
               msi.locator_type
        from   mtl_item_sub_inventories misi,
               mtl_secondary_inventories msi
        where  misi.secondary_inventory = msi.secondary_inventory_name
          and  misi.organization_id = msi.organization_id
          and  misi.inventory_item_id = itemID
          and  misi.organization_id = orgID
          and  misi.secondary_inventory like invName || '%'
          and  misi.secondary_inventory <> 'AX_INTRANS'
	  and  inv_material_status_grp.is_status_applicable(
                           NULL, -- p_wms_installed,
                           NULL,
                           trxTypeID, -- p_trx_type_id (is this same as trx_type_id?)
                           NULL,
                           NULL,
                           orgID,
                           itemID,
                           msi.secondary_inventory_name,
                           NULL,
                           NULL,
                           NULL,
                           'Z') = 'Y'
        order by misi.secondary_inventory;

Line: 93

    select stock_locator_control_code
      into orgLevelCtl
    from   mtl_parameters
    where  organization_id = orgID;

Line: 103

    select locator_type
      into subinvLevelCtl
    from   mtl_secondary_inventories
    where  organization_id = orgID
      and  secondary_inventory_name = subinv;

Line: 115

    select location_control_code
      into itemLevelCtl
    from   mtl_system_items
    where  inventory_item_id = itemID
      and  organization_id = orgID;

Line: 142

    select restrict_locators_code
      into restrictLocatorCode
    from   mtl_system_items
    where  inventory_item_id = itemID
      and  organization_id = orgID;

Line: 151

        select inventory_location_id,
               concatenated_segments
        from   mtl_item_locations_kfv
        where  organization_id = orgID
          and  subinventory_code = subinv
          and  concatenated_segments like locName || '%'
	  and  inv_material_status_grp.is_status_applicable(
                           NULL, -- p_wms_installed,
                           NULL,
                           trxTypeID, -- p_trx_type_id (is this same as trx_type_id?)
                           NULL,
                           NULL,
                           orgID,
                           itemID,
                           NULL,
                           inventory_location_id,
                           NULL,
                           NULL,
                           'L') = 'Y'
        order by concatenated_segments;

Line: 174

        select msl.secondary_locator,
               milk.concatenated_segments
        from   mtl_secondary_locators msl,
               mtl_item_locations_kfv milk
        where  msl.organization_id = milk.organization_id
          and  msl.secondary_locator = milk.inventory_location_id
          and  msl.subinventory_code = milk.subinventory_code
          and  msl.inventory_item_id = itemID
          and  msl.organization_id = orgID
          and  msl.subinventory_code = subinv
          and  milk.concatenated_segments like locName || '%'
	  and  inv_material_status_grp.is_status_applicable(
                           NULL, -- p_wms_installed,
                           NULL,
                           trxTypeID, -- p_trx_type_id (is this same as trx_type_id?)
                           NULL,
                           NULL,
                           orgID,
                           itemID,
                           NULL,
                           inventory_location_id,
                           NULL,
                           NULL,
                           'L') = 'Y'
        order by milk.concatenated_segments;