APPS.AHL_MC_ITEMGROUP_PUB SQL Statements

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

Line: 72

     SELECT item_group_id,
            type_code
     FROM ahl_item_groups_b
     WHERE name = p_grp_name;

Line: 79

     SELECT name,
            type_code
     FROM ahl_item_groups_b
     WHERE item_group_id = p_item_grp_id;

Line: 245

		      FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NOUPDATE');

Line: 272

		      FND_MESSAGE.Set_Name('AHL','AHL_MC_IG_TYPE_NOUPDATE');

Line: 476

     SELECT organization_id
     FROM mtl_parameters
     WHERE organization_code = p_org_code;

Line: 483

     SELECT inventory_item_id
     FROM  ahl_mtl_items_non_ou_v
     WHERE concatenated_segments = p_inventory_item_name
     AND   inventory_org_id = p_inv_organization_id;

Line: 491

     SELECT concatenated_segments
     FROM  ahl_mtl_items_non_ou_v
     WHERE inventory_item_id = p_inventory_item_id
     AND  inventory_org_id = p_inv_organization_id;

Line: 500

     SELECT item_association_id
     FROM ahl_item_associations_vl
     WHERE item_group_id = p_item_grp_id
     AND   inventory_org_id = p_inventory_org_id
     AND   inventory_item_id = p_inventory_item_id;